sqlserver2005 查询某个表的所有字段

比如查询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'