SQL statement Add description

-- CREATE TABLE table (name varchar (tenint)

--add descriptive information to the table execute sp_addextendedproperty N'ms_description','Table Description'N'User'N'dbo'N'Table'N'Table', NULL, NULL--Add description information for field name execute Sp_addextendedproperty N'ms_description','name'N'User'N'dbo'N'Table'N'Table'N'column'N'name'--Add description information for field A2 execute sp_addextendedproperty N'ms_description','Age'N'User'N'dbo'N'Table'N'Table'N'column'N' Age'--Update the Description property of the column A1 in the table: EXEC sp_updateextendedproperty'ms_description','Field 1','User'Dbo'Table','Table','column', name--Delete the Description property of the column A1 in the table: EXEC sp_dropextendedproperty'ms_description','User'Dbo'Table','Table','column', name

SQL statement Add description