sql语句

--查询数据库里的表名

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')