Generating a create table script

Online Help

Introducing Progress DB Navigator : Tasks : Common tasks for supported databases : SQL scripting : Generating a create table script

When you select a table node in the DB Structure view and right-click, the context menu contains an option for running a SQL script that creates a table. When you select Create Table Script from the context menu, a script appears in the SQL Editor. You can use the script to generate the SQL code needed to create a copy of the schema of the selected table.

Note: If you try to execute the script as it is, it fails because the table already exists. At the very least, you must make the name unique for the new table before you execute the script.(For OpenEdge database tables only) Be aware that Create Table Script does not generate the extended SQL syntax for defining OpenEdge attributes such as Format or Label.