Table Descriptions also stored back to DB?

Mar 17, 2010 at 12:03 PM

I know the column descriptions are stored back to the table.  Great.  

Is the same true for the Table descriptions?   If so, where?   I have never seen a way to enter a Table description from SQL Server Management Studio/

Mar 17, 2010 at 6:59 PM

Hi,

of course are the descriptions of tables, views, functions and so on, stored in the database.

You can view and edit them in the properties of the table in the extended properties tab.

 

best  regards

Jun 16, 2010 at 4:49 PM
Right-Click the Table name and go to Properties. Click the extended properties and you will see it on the right.