Support Forums - View Thread

View Thread

The following is the text of the current message along with any replies.

Messages 1 to 2 of 2 total

Fri, Jan 9 2009 3:58 AM	Permanent Link
"Iztok Lajovic"	Hi all, how can I get the list of all tables in a database? I need names of all tables but using EDBDatabase component I get active tables only. I think I need a SQL statement on information schema but I don't know how to address infromation schema. Iztok Lajovic
Fri, Jan 9 2009 4:46 AM	Permanent Link
Roy Lambert NLH Associates Team Elevate	Iztok SELECT Name FROM Information.Tables Make sure the query is pointing to the database you want. Roy Lambert [Team Elevate]