The IN_DB_UTIL_SP_GET_TABLE_DDL stored procedure generates and displays the DDL for the specified table. If no table name is specified then all tables in the inuser schema will be generated and displayed.
| Parameter | Description | |
|---|---|---|
| TABLE_NAME | Type: | INPUT |
| Datatype: | SYSNAME | |
| Default Value: | NULL | |
| Description | The name of the table for which to generate the DDL. | |
| Options | Any valid table in the inuser schema. | |
| DEBUG | Type: | INPUT |
| Datatype: | NVARCHAR(3) | |
| Default Value: | NO | |
| Description | Specifies whether to display the procedure name during execution. | |
| Options |
YES NO |
|
| V_RETURN_VAL | Type: | OUTPUT |
| Datatype: | INTEGER | |
| Default Value: | 0 | |
| Description | Specifies whether the execution of the
procedure was successful or not. 0 = Success 1 = Error |
|
Examples
EXEC IN_GET_TABLE_DDL 'IN_DOC'