-
table column comments SQL Server 2000
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.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
|