Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Development (2000)
 Create Table Description

Author  Topic 

tjforce
Starting Member

8 Posts

Posted - 2006-07-05 : 16:24:20
SQL 2005

I have a question about the Description.
If you have the following:

CREATE TABLE myTable
name VARCHAR(50) NOT NULL,
address VARCHAR(25),
etc...

How do you add a Description to the field? i.e. field: name description: This contains First, Middle and Last Name information

X002548
Not Just a Number

15586 Posts

Posted - 2006-07-05 : 16:30:04
I would keep my data dictionary in a separate table...but if you still want to look up extended properties in BOL


Brett

8-)

Hint: Want your questions answered fast? Follow the direction in this link
http://weblogs.sqlteam.com/brettk/archive/2005/05/25/5276.aspx

Add yourself!
http://www.frappr.com/sqlteam
Go to Top of Page
   

- Advertisement -