Skip to main content

Create a Database node's tables in its database

POST 
/api/database_node_create_tables/:project_guid/:workflow_guid/:node_guid

Creates each table in create with CREATE TABLE as the Schema Editor writes it - the statements database_node_create_tables_sql shows. A table in replace (which must also be in create, with confirm_replace) is dropped first, losing its rows; any other table that already exists is left as it is and reported. A table in alter is changed in place as its plan says (SCHMdbAlter), and only when its SQL is what the user reviewed (expected). Each table's statements run in one transaction, except on Oracle. Each table is its own step, so one failing doesn't stop the rest.

Request​

Responses​

Successful Response