select name from syscolumns where id=object_id('表名')
读取数据库名及表与表中的字段 选择一个服务器后,列出该服务器中所有数据库: Select * from Master.dbo.sysdatabases;
选择一个库后读该库中表: select * from dbo.sysobjects where OBJECTPROPERTY(id, N'IsUserTable') = 1;
列出表中的字段: select c.name as ColumnName, c.colorder as ColumnOrder, c.xtype as DataType, typ.name as DataTypeName, c.Length, c.isnullable from dbo.syscolumns c inner join dbo.sysobjects t on c.id = t.id inner join dbo.systypes typ on typ.xtype = c.xtype where OBJECTPROPERTY(t.id, N'IsUserTable') = 1 and t.name='" + tableName + "' order by c.colorder";