The IN_DB_UTIL_SP_DROP_PK stored procedure is used to drop the Primary Key constraint on the specified table. This procedure is intended to be used by the IN_DB_UPGRADE package for schema upgrade actions.
All tables in the inuser schema have a primary key constraint that is a clustered index. Dropping the primary key clustered index will convert the table into a heap and any existing nonclustered indexes will be rebuilt. Any referencing foreign key constraints must be dropped prior to being able to drop a primary key constraint.
Any referencing foreign key constraints must be dropped prior to being able to drop a primary key constraint.
| Parameter | Description | |
|---|---|---|
| TABLE_NAME | Type: | INPUT |
| Datatype: | SYSNAME | |
| Default Value: | NULL | |
| Description | The name of the table for which to drop the primary key constraint. | |
| DEBUG | Type: | INPUT |
| Datatype: | NVARCHAR(3) | |
| Default Value: | NO | |
| Description | Specifies whether to display additional debugging information during execution, including background operations such as session setup and state changes and call stack details. | |
| Options | YES = Display additional details to the Messages tab NO = Do not display additional details to the Message tab |
|
| 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
DECLARE @V_RETURN_VAL INT EXEC @V_RETURN_VAL = IN_DROP_PK 'IN_DOC' PRINT @V_RETURN_VAL EXEC IN_DROP_PK 'IN_DOC'