SELECT ST.name AS tableName,SL.name ColumnName FROM SYSOBJECTS ST
LEFT JOIN SYSCOLUMNS SL ON OBJECT_ID(ST.name)=SL.id
WHERE ST.TYPE='U'
ORDER BY ST.name
1、select * from sysobjects where xtype='u'
2、SELECT COLUMN_NAME,DATA_TYPE FROM INFORMATION_SCHEMA.columns WHERE TABLE_NAME=表名
内容全部来源于网络收集，如有侵权，请联系网站删除：QQ：24596024