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";