读取数据库中一张表的表头字段。。请教。。。

[shushusday]

如题

[gmfirefox]

select column_name from Information_Schema.columns where table_name=tablename

[okwang1979]

要是用MSSQL用syscolumns与sysobjects这两张表就搞定了。

[JasonHeung]

--获取指定表的列信息
CREATE PROCEDURE DBO.JH_GETUSERCOLUMNS @TABLEIDp INTEGER AS
SELECT NAME,ID,XTYPE,TYPESTAT,XUSERTYPE,LENGTH,COLID,XPREC,XSCALE,COLSTAT,ISOUTPARAM,isnullable,tdscollation FROM SYSCOLUMNS
WHERE ID = @TABLEIDp
GO


--获取表ID
--作者;xianglingding
--时间：2005-04-26
CREATE PROCEDURE DBO.JH_GetTableID @tableName varchar(50) AS
SET NOCOUNT ON
SELECT id from sysobjects where name = @tableName
GO


DataSet ds = new DataSet;
.....

ds.Tables[0].Columns.