sql2000 Add table comments, column comments, and modify Delete comments

--Create a table
--create table tables (A1 varchar), A2 char (2))

--Add descriptive information to the table
EXECUTE sp_addextendedproperty ' ms_description ', ' Personnel information table ', ' user ', ' dbo ', ' table ', ' Tables ', NULL;

--Add descriptive information for field A1
EXECUTE sp_addextendedproperty ' ms_description ', ' name ', ' user ', ' dbo ', ' table ', ' table ', ' column ', ' A1 '

--Add descriptive information for field A2
EXECUTE sp_addextendedproperty N ' ms_description ', ' Gender ', ' user ', ' dbo ', ' table ', ' table ', ' column ', ' A2 '

--Update the Description property of the column A1 in the table:
EXEC sp_updateextendedproperty ' ms_description ', ' Field 1 ', ' user ', dbo, ' table ', ' table ', ' column ', A1

--Delete The Description property of the column A1 in the table:
--exec sp_dropextendedproperty ' ms_description ', ' user ', dbo, ' table ', ' Tables ', ' column ', A1

--Delete test
--drop Table Tables

EXEC sp_addextendedproperty n ' ms_description ', n ' basic information _ excipients Inventory table (useless) ', n ' user ', n ' dbo ', n ' table ', n ' BASE_FLKC ';
EXEC sp_addextendedproperty n ' ms_description ', n ' basic information _ excipient Information table (useless) ', n ' user ', n ' dbo ', n ' table ', n ' base_flxx ';

sql2000 Add table comments, column comments, and modify Delete comments