获取数据表字段名给出一种数据库解决办法100分

[java悠悠]

对目前流行数据库查询表中的字段名，一种数据库100分，另开贴给分，谢谢

[子陌红尘]

SQL Server：
select name from syscolumns where id=object_id('表名')

[java悠悠]

to libin_ftsafe(子陌红尘) 到下面接分
http://community.csdn.net/Expert/topic/4401/4401908.xml?temp=.669491
谢谢

[子陌红尘]

Oracle：
select column_name from user_tab_columns where table_name = upper('TableName')

[ericofred]

SQL Server：
select a.name from syscolumns a ，sysobjects b where a.id=b.id and b.name=('表名')

[java悠悠]

谁有DB2的?

[jhtchina]

Mark

[into_the_sky]

晕，我还专门写了个很长的东东来查，原来这么简单。。。。。。。。

[新鲜鱼排]

mark

[rfq]

ALTER proc GetAllColumns as

declare @strTableName varchar(100)
declare @strSql varchar(1000)
--declare @strname varchar(1000)

declare CurS cursor
for
select name from Sysobjects where xtype=N'u' and objectproperty(id,N'IsUserTable')=1 and name like'Prj_%'
open Curs
fetch next from Curs into @strTableName
while (@@fetch_status=0)
begin
--set @strSql='delete from '+@strTableName +' where 工程编号='''+@strProNo+''''
--exec(@strSql)
-- set @strname=''''
print @strtablename
exec('declare @strname varchar(1000)
set @strname=''''
select @strname=@strname+name+'','' from Syscolumns where id=object_id('''+@strTableName+''')
print @strname ') --PRINT @strname
fetch next from Curs into @strTableName
print ''
end
close Curs
deallocate curs