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 row_value
FROM sa_split_list( sa_get_table_definition( 'GROUPO', 'Departments'), CHAR(10));