Generate a create table script
- Last Updated: November 27, 2024
- 1 minute read
- OpenEdge
- Version 12.8
- Documentation
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.