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 !=''