Populate a dropdown menu with names of db tables...?

[shadowspell]

Hi,

Just as one can populate a <select> tag with fields read from a table, can populating a <select> tag with table names read from a database also be done?
Thanks for any help, my book doesn't seem to address this.
Chris
~`^%

 

[SQLSister]

I think it would depend on the database and how it stores the naems. Certainly you can do this relatively easily in SQL server with the following query

SELECT Table_Name
FROM yourdatabasename.INFORMATION_SCHEMA.tables

Questions about posting. See faq183-874