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)  

 

转载于:https://my.oschina.net/u/2378036/blog/673289