php sqlerver,sqlerver索引列

DECLARE @tablename VARCHAR(100), @columnname VARCHAR(100), @tab VARCHAR(100)

SET @tablename='AP_DVS_CAMMERA'

SET @columnname='SC_PORT'

declare @defname varchar(100)

declare @cmd varchar(100)

select @defname = name

FROM sysobjects so

JOIN sysconstraints sc

ON so.id = sc.constid

WHERE object_name(so.parent_obj) = @tablename

AND so.xtype = 'D'

AND sc.colid =

(SELECT colid FROM syscolumns

WHERE id = object_id(@tablename) AND

name = @columnname)

select @cmd='alter table '+ @tablename+ ' drop constraint '+ @defname

if @cmd is null print 'No default constraint to drop'

exec (@cmd)