Submit My Question - Recent Questions - Recent Answer
Msdn Tech >> SQL Server >> SQL Server Database Engine

table designer / database description in 2005?

SQL Server Management Studio 2005 / table designer doesn't appear to have a field for table description; there IS a field for column description, but not for table. In SQL Server 2000 you right-clicked in the table designer and there was a table description field; I've got to be missing something obvious, right?
[315 byte] By [mruniqueid] at [2007-12-25]
«« The process cannot access the file because it is being used by another process
»» Downloading files from IIS 6
# 1
So is everybody stumped ;-0 ? Does anyhbody ever document their databases in Server Management Studio, or am I the only one?
mruniqueid at 2007-9-3 > top of Msdn Tech,SQL Server,SQL Server Database Engine...
# 2

I was also seeking that descriptions for a long time and I think I've found way how to display and mofify them:

  • Right click on the table name in the "Tables" branch of the database tree and choose Modify from the context menu.

  • Than view Properties window (e.g. pressing the F4 key)
    The "Description" property should be shown there

The description text is also available in the Properties pop-up window (right click on the table name and choose Properties from the context menu) as an Extended property named "MS_Description".

BTW - does not anybody know how to generate table and column descriptions from Visio 2005 EA database models?

JanSotola at 2007-9-3 > top of Msdn Tech,SQL Server,SQL Server Database Engine...
SQL Server
SQL Server Database Engine

SQL Server Hot Topic

SQL Server New Topic

SQL Server

Java / MSDN / Linux Tech / PHP Tech / MSDN DotNet / MSDN TECH / Health Library / Programmers Tech / visual basic Tech / Developer Tech / Ipod faqs / Msdn China Tech

Site Classified