Jack.G

摘要： 1：获取某表的列名select 列名=name from syscolumns where id=object_id(表名')2：获取数据库表中的表名select 表名=name from sysobjects where objectproperty(id, 'isusertable ')=13:获取数据库表中的列名、字段类型、字段长度select o.name as tbname, c.name as columnname, (case t.name when 'int' then '数字类型'when 'datetime&# 阅读全文