获得表字段名称和数据类型

select syscolumns.name,systypes.name as type from syscolumns 
 inner join sysobjects on syscolumns.id  =  sysobjects.id 
 inner join systypes on syscolumns.xtype   =   systypes.xtype 
 where (sysobjects.name   =   '" + tableName + "')   
    and (systypes.name   <>   'sysname')

转载于:https://www.cnblogs.com/chengeng/p/3338823.html