CREATE TABLE aa(
[id] int IDENTITY (1,1) NOT NULL,
[name] varchar(100) NULL,
[pass] varchar(100) NULL,
PRIMARY KEY (id)
)
GO
[id] int IDENTITY (1,1) NOT NULL,
[name] varchar(100) NULL,
[pass] varchar(100) NULL,
PRIMARY KEY (id)
)
GO
EXECUTE sp_addextendedproperty N'MS_Description', '姓名', N'user', N'dbo', N'table', N'表', N'column', N'a1'
不过可以创建表以后用系统存储过程添加描述。
EXEC sp_addextendedproperty N'MS_Description',N'字段描述',N'user',N'dbo',N'table',N'表名称',N'column',N'字段名称'