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 strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Request "Description" column

Status
Not open for further replies.
saturnius

saturnius

Technical User
May 7, 2002
22
GB
Hi,
I am looking for a SQL command to access the "Description" Column in MS Access. With the SQL Server I can use:

SELECT cast(objname as Nvarchar(100)) as ob,
cast(value as Nvarchar(100)) as va FROM ::FN_LISTEXTENDEDPROPERTY('MS_Description','User','dbo','table','myTab','column', default)

This will give me all the column names and descriptions. Is there something similar in MS Access? Many thanks in advance!
Cheers
Saturnius
 
Sort by date Sort by votes
The description property of a field is not exposed through SQL. You would need to use code to retrieve this.

Duane
MS Access MVP
Find out how to get great answers faq219-2884.
 
Upvote 0 Downvote
Hi,
Thanks for the fast answer. What kind of code do you mean?
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

EM1107
  • Locked
  • Question
populate a column with time from other column.
Replies
1
Views
119
Andrzejek
Andrzejek
arpeggione
  • Locked
  • Question
"Updates Available" banner - disable Updates not working - Office 2016
Replies
1
Views
88
Darrylles
Darrylles
lameid
  • Locked
  • Question
"System Resources Exceeded" Compact and Repair
Replies
2
Views
76
dhookom
dhookom
lameid
  • Locked
  • Question
"Intel is in serious trouble. ARM is the Future." - Is this the beginning of the end?
Replies
0
Views
51
lameid
lameid
bigdavidt
  • Locked
  • Question
"The recordset is not updatable."
Replies
2
Views
111
bigdavidt
bigdavidt

Part and Inventory Search

Sponsor

Back
Top