Show Me
 

Exporting DDL

Previous previous|next Next Page

You can export some or all objects of one or more types of database objects to a file containing SQL data definition language (DDL) statements to create these objects. This is useful for when you want to recreate database objects in another schema, for example, moving from development to production.

Sheila would like to provide the DEPENDENTS table and its data to another department. Sheila can produce a DDL file with the database object information.

Help Sheila export the DDL file that contains the DEPENDENTS table information.

Launch Demonstration

Show Me and Try It