Database Discussion - SQL Server

Print Page | Close Window

SQL Server - Column Description

Printed From: Web Wiz Forums
Category: General Discussion
Forum Name: Database Discussion
Forum Description: Discussion and chat on database related topics.
URL: https://forums.webwiz.net/forum_posts.asp?TID=7262
Printed Date: 30 March 2026 at 3:35pm
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com

Topic: SQL Server - Column Description

Posted By: Gary
Subject: SQL Server - Column Description
Date Posted: 14 November 2003 at 3:56am

1. Is it possible to add descriptions/comments against each column like you can in MS Access ???

2. If this is possible, can the descriptions be 'queried' and displayed on an asp page ???

Thx

(I'm using SQL Server 2000 Ent Mgr to connect to a SQL Server v7 which doesnt seem to support column descriptions)

Replies:

Posted By: Gary
Date Posted: 14 November 2003 at 6:52am

Figured it out.....

1) The column description is an extended property and is not supported in SQL 7.

2) With SQL 2000, you can query system tables to extract any extended property from a table.