SQL 查看表每一个列的名字以及类型

select a.name,b.name from sys.columns as 
a join sys.types as b on a.system_type_id=b.system_type_id
where object_id=(select object_id from sys.tables where name='c_PROJECT')