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!
-
Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Does Access have an equivalent to Oracle's DESCRIBE
- Thread starter jpaaron
- Start date
Hi
I am not aware of a direct replacement for DESCRIBE but:
You can do this in code by iterating through the tabledefs collection.
Or
You can do it using a query based on the system table MSysObjects. This table contains details of objects other than tables so you will have to choose an appropriate criteria, try SELECT * FROM MSysObjects WHERE Type = 6, to begin with
Regards Regards
Ken Reay
Freelance Solutions Developer
Boldon Information Systems Ltd
UK
kenneth.reaySPAMNOT@talk21.com
remove SPAMNOT to use
I am not aware of a direct replacement for DESCRIBE but:
You can do this in code by iterating through the tabledefs collection.
Or
You can do it using a query based on the system table MSysObjects. This table contains details of objects other than tables so you will have to choose an appropriate criteria, try SELECT * FROM MSysObjects WHERE Type = 6, to begin with
Regards Regards
Ken Reay
Freelance Solutions Developer
Boldon Information Systems Ltd
UK
kenneth.reaySPAMNOT@talk21.com
remove SPAMNOT to use
- Status
Similar threads
- Locked
- Question
- Locked
- Question
