SELECT * FROM syscolumns
SELECT * FROM sysobjects
SELECT * FROM sys.indexes
SELECT * FROM sys.index_columns
SELECT * FROM sys.key_constraints
SELECT * FROM sys.types
SELECT * FROM sys.default_constraints
可根据以上表组合获取表字段相关信息
SELECT * FROM syscolumns
SELECT * FROM sysobjects
SELECT * FROM sys.indexes
SELECT * FROM sys.index_columns
SELECT * FROM sys.key_constraints
SELECT * FROM sys.types
SELECT * FROM sys.default_constraints
可根据以上表组合获取表字段相关信息