DECLARE @COL VARCHAR(50) DECLARE @SQL VARCHAR(100)SELECT @COL = NAME FROM SYSCOLUMNS WHERE ID = OBJECT_ID('XXX') AND COLID = 4SET @SQL = 'alter table xxx drop column ' + @COLEXEC(@SQL)
declare @sql varchar(1000) select @sql='alter table tb drop column '+name from sys.columns where object_id=object_id('tb') and column_id=4 exec (@sql)
CREATE TABLE TB(ID INT,CODE VARCHAR(32),NAME VARCHAR(32),ADDRESS NVARCHAR(128),COMMENT NVARCHAR(256))DECLARE @COL NVARCHAR(128) SELECT @COL=B.name FROM sys.tables A JOIN sys.columns B ON A.object_id =B.object_id WHERE A.name ='TB' AND B.column_id=4DECLARE @SQL VARCHAR(MAX) SET @SQL =' ALTER TABLE TB DROP COLUMN '+@COL+''EXEC (@SQL)
DECLARE @SQL VARCHAR(100)SELECT @COL = NAME FROM SYSCOLUMNS
WHERE ID = OBJECT_ID('XXX')
AND COLID = 4SET @SQL = 'alter table xxx drop column ' + @COLEXEC(@SQL)
select @sql='alter table tb drop column '+name
from sys.columns where object_id=object_id('tb') and column_id=4
exec (@sql)
SELECT @COL=B.name FROM sys.tables A JOIN sys.columns B ON A.object_id =B.object_id
WHERE A.name ='TB' AND B.column_id=4DECLARE @SQL VARCHAR(MAX)
SET @SQL ='
ALTER TABLE TB DROP COLUMN '+@COL+''EXEC (@SQL)