SQL运用记录

--读取库中的所有表名
--1.
select name from sysobjects where xtype='u'
--读取指定表的所有列名
select name from syscolumns where id=(select max(id) from sysobjects where xtype='u' and name='表名')
--得到表中列的描述内容
select a.name,g.value from syscolumns as a left join sysproperties g   on a.id=g.id AND a.colid = g.smallid where a.id=Object_id('表名')

--获取表的字段列名很说明及类型

select distinct a.name,g.value,type_name(a.xtype) as typename  from syscolumns as a 
left join sysproperties g on a.id=g.id AND a.colid = g.smallid 
where a.id=Object_id('ou_Project') and g.value is not null and g.value !=''