我只想保留SQL 表 F_ID 一个字段﹐其它全部删除。动态的请问怎幺做呀﹖

[Ngg]

同上~~谢谢

[zhangl_cn]

用SQL语句

[firstshine]

你要用到数据字典，找到该表的所有字段，删除不是f_id的所有字段，各种数据库的数据字典不一样，还要看你是什么样的数据库

[chinaandys]

到查询分析器或写成存储过程去执行

declare @i int,@Col varchar(50)
select @i=count(*) from syscolumns where id=object_id('test') where name<>'F_ID'

while @i>0
begin
select @Col=name from syscolumns where id=object_id('test') and name<>'F_ID'
alter table 表名
drop columns @Col
set @i=@i-1
end
go

[chinaandys]

搞错修改一下:

declare @i int,@Col varchar(50)
select @i=count(*) from syscolumns where id=object_id('test') and name<>'F_ID'

while @i>0
begin
select @Col=name from syscolumns where id=object_id('test') and name<>'F_ID'
alter table 表名
drop columns @Col
set @i=@i-1
end
go

[chinaandys]

Sorry,已经测试:
------------
declare @i int, @Col varchar(50)
select @i=count(*) from syscolumns where id=object_id('表名') and [name]<>'F_ID'

while @i>0
begin
select @Col=[name] from syscolumns where id=object_id('表名') and [name]<>'F_ID'
exec('alter table 表名 drop column '+@Col+'')
set @i=@i-1
end
go