Table/ColumnName descriptors in SQL Server 7.0?

[achin]

How does one go about adding descriptions of Column Names in a database? In MS-Access, a Description field was provided when defining the columns in a table. As well, a description could be added to the Properties dialog for a Table.

I've been unable to find the equivalent capability in SQL Server.

Thanks,
Andrew

 

[tlbroadbent]

In SQL 7 and 2000 you can import the database structure into the Metadata repository and add comments, descriptions, etc.

In SQl 2000, you can add descriptions in the table design screen. Terry

http://members.home.net/tlbroadbent/prog.htm

_____________________________________
Man's mind stretched to a new idea never goes back to its original dimensions. - Oliver Wendell Holmes

 

[achin]

Thanks for pointing me in the right direction. I'll pursue the Metadata repository further.

Andrew