enumeration over all tables of database-connection

[ganders]

hi folks

is there a way to get an enumeration over all tables of a db-connection? i need to retrieve tables from a databsae, without knowing theire names and the exact count.

best regards

george

 

[PlausiblyDamp]

What database are you using? If you are using SQL server you could simply query the INFORMATION_SCHEMA.Tables view for them.

 

[ganders]

im using oracle 9...