十七玄月

摘要： use dbname-- 查看表所有字段Select * from syscolumns Where ID=OBJECT_ID('表名') ORDER BY id SELECT * FROM sysobjects WHERE (xtype = 'U') go xtype可替换为如下参数 --C = CHECK 约束 --D = 默认值或 DEFAULT 约束 --F = FOREIGN ... 阅读全文