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!

How do I get table descriptions?

Status
Not open for further replies.
ed9871

ed9871

Programmer
Jan 15, 2002
14
0
0
US
Using an SQL statement, how do I get the description of a table and all its fields? In Oracle I can use "DESC tablename", and others use "description". Access has these as keywords, but I can't get it to work. Any ideas?

Ed
 
Sort by date Sort by votes
The table and field descriptions in Access are stored in VBA. You can return them that way.
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

serino
  • Locked
  • Question
Delete From Table
Replies
1
Views
226
Andrzejek
Andrzejek
lameid
  • Locked
  • Question
SELECT FROM Table in Another Access File
Replies
2
Views
303
lameid
lameid
caykamanj1966
  • Locked
  • Question
Get Yesterday's Date
Replies
1
Views
110
caykamanj1966
caykamanj1966
accesshelp1
  • Locked
  • Question
How can I remove parenthesis and everything that comes after it? 1
Replies
3
Views
271
Andrzejek
Andrzejek
TrekBiker
  • Locked
  • Question
Records in one table not in another 1
Replies
3
Views
125
Andrzejek
Andrzejek

Part and Inventory Search

Sponsor

Back
Top