I'm sure this has been asked before, and I apologize,<BR>but I need to display the names of all of my tables in my database. What ASP code will accomplish this for me?<BR><BR>Thanks in advance!
<% Const adSchemaTables = 20<BR> Dim rstSchema<BR> Set rstSchema = dbConn.OpenSchema(adSchemaTables)<BR><BR> Response.write ("<select name=Tables>")<BR> Do Until rstSchema.EOF<BR> If (rstSchema("TABLE_TYPE") <> "SYSTEM TABLE") Then<BR> Response.Write ("<option value='" & rstSchema("TABLE_NAME") & "'>" & rstSchema("TABLE_NAME") & vbCRLF)<BR> End If<BR> rstSchema.MoveNext<BR> Loop<BR> Response.write("</select>")<BR>%>
select * from sysobjects where type = 'U'
there is an easier way if you are using MS SQL.....read my post.<BR><BR>
SOrry..I'm new to ASP. I put the code you gave me into a sql statement on my page, and I got an error back. Is there anything else I need?
you have to give me a crystal ball so i can figure what the error is...or sign me up for a few mind reading cources.<BR><BR><BR>What is the error?? show some RELAVENT code.<BR><BR><BR><BR>
it's not the first time you spell "relEvant" wrong. Take some English classes,please.
He who is in glass houses....<BR><BR>Plus we capitalize the first letter in a sentence.