Deploying data objects to a database
You can define, generate, and apply SQL Data Definition Language (DDL) statements in the Data Definition view of the Data perspective. You can generate SQL DDL statements for only DB2 Universal Database databases.
Data Definition Language (DDL) is a subset of SQL. It is a language for describing data and its relationships in a database. Use the Generate SQL DDL wizard to generate SQL DDL statements used to recreate a database object.
You might want to generate SQL DDL statements for database objects for the following reasons:
- To keep a snapshot of what the current state of the database.
- To set up a test system where the database acts like the production system but contains no data.
To deploy data objects to a database:
Deploy data definitions to a database server outside of the workbench
Deploy a database or database objects to a database server. The database server can be on the local computer or remote server.Create an SQL DDL script
Create an SQL DDL script to define or work with existing database objects.Generate an SQL DDL file for an existing data object
Generate an SQL DLL file for a database object. You can use SQL DDL statements to change the structure of the database. For example, you can define a table, change the definition of a table, or remove a table.Edit an SQL DDL file
Edit an SQL DDL file after you generate it.Run DDL scripts on a local database
Run a DDL script on a local data definition which creates data definition objects that are defined in the script.Run DDL scripts on a remote database
Deploy the statements in an SQL DDL file by running the script on a remote database.
Parent topic
Acces and update data