小弟我这个触发器如何就错了？ 阿

我这个触发器怎么就错了？ 十万火急阿
我是菜鸟 请高手帮我看看

if exists(select * from sysobjects where id=object_id('AlterTableLine') )
  drop TRIGGER AlterTableLine
go

CREATE TRIGGER [AlterTableLine] ON [dbo].[ShibanLineName] 
FOR DELETE 
AS
declare @LineName varChar(50)

select @LineName=i.列名称 from deleted i

ALTER TABLE profollow DROP COLUMN @LineName 

go

[解决办法]
ALTER TRIGGER [AlterTableLine] ON [dbo].[ShibanLineName]
after delete
AS 
declare @LineName varChar(50) 

select @LineName=i.列名称 from deleted i 

EXEC ('ALTER TABLE profollow DROP COLUMN '+ @LineName) //列名为变量时须用动态SQL

[解决办法]

SQL code

declare     @TableName sysname,    @ColumnName sysname/*******************************************************************************//*                                                                             *//*     注意:此更改不支持带索引的关键栏位                                       */       /*                                                                             *//*                            以上内容不可异动                                 *//*                                                                             *//****************************************************x