The IN_DB_UTIL_SP_GET_INDEX_DDL stored procedure generates and displays the index DDL for the specified index or table.
| Parameter | Description | |
|---|---|---|
| TABLE_NAME | Type: | INPUT |
| Datatype: | SYSNAME | |
| Default Value: | NULL | |
| Description | Specifies the table name for which to generate the index DDL. If a table name is not specified then all indexes for all tables in the inuser schema will be generated and displayed. | |
| Options | Any valid table in the inuser schema. | |
| INDEX_NAME | Type: | INPUT |
| Datatype: | SYSNAME | |
| Default Value: | NULL | |
| Description | Specifies the index name for which to generate the DDL. If the index name is not specified then all indexes for the specified table will be generated and displayed. | |
| Options | Any valid index for the specified table. | |
| 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
DECLARE @V_RETURN_VAL INT EXEC @V_RETURN_VAL = IN_GET_INDEX_DDL 'IN_DOC' PRINT @V_RETURN_VAL EXEC IN_GET_INDEX_DDL 'IN_DOC' EXEC IN_GET_INDEX_DDL 'IN_DOC', 'DOC_IDX2' EXEC IN_GET_INDEX_DDL NULL, 'DOC_IDX2'