How do I create or add them with/to a table in SQL Server 2000?
Printable View
How do I create or add them with/to a table in SQL Server 2000?
If you are in EM, go to design table and when you click on a column you can add description at the bottom.
If you like to view all the descriptions execute the following command.
select object_name(id), name from sysproperties
Or add column comments with sp_addextendedproperty, and view them with fn_listextendedproperty.