SQL Server table and column notes additions and deletions change

--Create a tableCreate TableTable (A1varchar(Ten), A2Char(2))--add descriptive information to a tableEXECUTESp_addextendedproperty N'ms_description','Personnel Information Sheet'N'User'N'dbo'N'Table'N'Table',NULL,NULL--Add descriptive information for field A1EXECUTESp_addextendedproperty N'ms_description','name'N'User'N'dbo'N'Table'N'Table'N'column'N'A1'--Add descriptive information for field A2EXECUTESp_addextendedproperty N'ms_description','Sex'N'User'N'dbo'N'Table'N'Table'N'column'N'A2'--Update the Description property of the column A1 in the table:EXECSp_updateextendedproperty'ms_description','Field 1','User'Dbo'Table','Table','column', A1--Delete the Description property of the column A1 in the table:EXECSp_dropextendedproperty'ms_description','User'Dbo'Table','Table','column', A1--Delete TestDrop TableTable

SQL Server table and column notes additions and deletions change