The IN_DB_UTIL_SP_GET_PK_DDL stored procedure generates and displays the primary key DDL for the specified table name or primary key name.
| Parameter | Description | |
|---|---|---|
| TABLE_NAME | Type: | INPUT |
| Datatype: | SYSNAME | |
| Default Value: | NULL | |
| Description | The name of the table for which to generate the primary key DDL. | |
| Options | Any valid table in the inuser schema. | |
| PK_NAME | Type: | INPUT |
| Datatype: | SYSNAME | |
| Default Value: | NULL | |
| Description | The name of the primary key constraint for which to generate the DDL. | |
| Options | Any valid primary key 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 |
|
Example
EXEC IN_GET_PK_DDL 'IN_DOC' EXEC IN_GET_PK_DDL NULL, 'PK_DOC'