sa_get_table_definition( 
@owner
, @tabname
)

This function returns a LONG VARCHAR string containing the SQL statements required to create the specified table and its indexes, foreign keys, triggers, and granted privileges. To create a new table with the same definition, use the string returned by this function with the EXECUTE IMMEDIATE statement and the LOCATE, SUBSTRING, and REPLACE functions.

You must have the SELECT ANY TABLE system privilege, or SELECT privilege on the SYSUSERPERM compatibility view.

None

• SYSUSERPERM compatibility view (deprecated)
• 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 function to display the string containing the SQL statements required to create the Departments table.

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