CODEWITHSUNDEEP
sqlms-access
Farna
Farna

Reputation: 1176

query for ms access

my query is "SELECT column_name, table_name FROM information_schema.columns" .but it execute true in sqlserver ,but it dosn't execute true in Ms Access.i want to get all colums and tables'name from specific database.thanks.

Upvotes: 0

Views: 84

Answers (1)

Michael Pakhantsov
Michael Pakhantsov

Reputation: 25390

Look to this question: How to extract the schema of an Access (.mdb) database?

Upvotes: 2

Related Questions