34,590
社区成员
发帖
与我相关
我的任务
分享
CREATE TABLE dbo.Table_1
(
id int NULL
) ON [PRIMARY]
GO
DECLARE @v sql_variant
SET @v = N'测试'
EXECUTE sp_addextendedproperty N'MS_Description', @v, N'SCHEMA', N'dbo', N'TABLE', N'Table_1', N'COLUMN', N'id'
GO
USE AdventureWorks2012;
GO
EXEC sp_addextendedproperty
@name = N'Caption',
@value = 'Postal code is a required column.',
@level0type = N'Schema', @level0name = 'Person',
@level1type = N'Table', @level1name = 'Address',
@level2type = N'Column', @level2name = 'PostalCode';
GO
联机丛书上有很多例子