比如查询ad表
select c.[name],t.[name],c.length,c.[isnullable] from sys.syscolumns c inner join sys.types t on c.xtype=t.user_type_id
inner join sys.sysobjects o on c.id=o.id
where o.[name]='Ad'
比如查询ad表
select c.[name],t.[name],c.length,c.[isnullable] from sys.syscolumns c inner join sys.types t on c.xtype=t.user_type_id
inner join sys.sysobjects o on c.id=o.id
where o.[name]='Ad'