How to read table names

<i><b>Originally posted by : codar (icodar@hotmail.com)</b></i><br />I want to get the names of all the tables in my database and put them into a select list.<br /><br />Then when the user select a table use it in a query:<br />if request("selectedtablename")<>"" then<br />sql="select * from "&request("selectedtablename")&" "<br />set rs=execute(sql) <br />end if<br /><br />