santosh-1039191
Newbie
Points: 1
More actions
March 13, 2009 at 2:39 am
#128570
Hi,
How can I write query to retrieve all table names from a database?
(Iam using MS-Access & Quest3D softwares).
Jack Corbett
SSC Guru
Points: 184397
March 13, 2009 at 7:05 am
#959066
You want to query the sys.tables view in the context of the database you want the table names from. For example querying it in master retrieves all the tables in master.
Jack CorbettConsultant - Straight Path SolutionsCheck out these links on how to get faster and more accurate answers:Forum Etiquette: How to post data/code on a forum to get the best help Need an Answer? Actually, No ... You Need a Question
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply