sa_get_table_definition( owner, tabname )
 

To create a new table with the same definition, use the string returned by the sa_get_table_definition system procedure with the EXECUTE IMMEDIATE statement and the LOCATE, SUBSTRING, and REPLACE functions.

DBA authority

None

• sa_split_list system procedure
• EXECUTE IMMEDIATE statement [SP]
• LOCATE function [String]
• SUBSTRING function [String]
• REPLACE function [String]

The following statement uses the sa_get_table_definition system procedure to display the string containing the SQL statements required to create the Departments table.

SELECT sa_get_table_definition( 'GROUPO', 'Departments');