Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

description information for views

Status
Not open for further replies.
kirstyn

kirstyn

Technical User
Jun 11, 2004
12
GB
Hi All

I have create some views in a SQL server 2000 database. The source tables and fields all have descriptions which i can access via information schema.

What i'd like to be able to do is provide similar descriptive information for the views as for the base tables (e.g a description of the purpose of each view to aid the users).

Is this possible? If so how?

cheers

krn
 
Status
Not open for further replies.

Similar threads

V
  • Locked
  • Question
xp_cmdshell vs psexec - this SQL server forgets credential to an W10 share
Replies
0
Views
376
Volvere
V
ahmedsa2018
  • Locked
  • Question
How to make pivot for features dynamically based on feature name and feature value ?
Replies
1
Views
121
TamarGranor
TamarGranor
grnzbra
  • Locked
  • Question
Conditional Foreign Key Constraint
Replies
1
Views
152
Chris Miller
Chris Miller
WomanPro
  • Locked
  • Question
Insert into query adds records to unreadable format, how do I change that? 1
Replies
5
Views
241
Chris Miller
Chris Miller
bmacbmac
  • Locked
  • Question
SQL 'For json' query for over 100,000 records - truncating results
Replies
2
Views
260
bmacbmac
bmacbmac

Part and Inventory Search

Sponsor

Back
Top