USP_DROP_PRIMARYKEY
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @SCHEMA | nvarchar(128) | IN | |
| @TABLENAME | nvarchar(128) | IN |
Definition
Copy
create procedure BBDW.[USP_DROP_PRIMARYKEY] (@SCHEMA nvarchar(128), @TABLENAME nvarchar(128)) as
if exists (select * from INFORMATION_SCHEMA.TABLE_CONSTRAINTS where CONSTRAINT_SCHEMA = @SCHEMA and TABLE_NAME = @TABLENAME and CONSTRAINT_NAME like 'PK_%')
begin
declare @SQL nvarchar(max)
set @SQL = 'alter table ' + @SCHEMA + '.[' + @TABLENAME + '] drop constraint [PK_' + @TABLENAME + ']'
exec sp_executesql @SQL;
end;