--查询数据库里的表名
select name from sysobjects where xtype='u'
--读取指定表的所有列名和列的字段类型
SELECT C.name AS ColumnName, T.name AS ColumnType
FROM syscolumns C
LEFT JOIN systypes T ON C.xusertype = T.xusertype
WHERE C.id = object_id('AD')
--查询数据库里的表名
select name from sysobjects where xtype='u'
--读取指定表的所有列名和列的字段类型
SELECT C.name AS ColumnName, T.name AS ColumnType