Ok, I realize that this has been posted a few times but all the information that's been supplied has been "select * from information_schema.tables" and whatever.... No display tips so I tried this:<BR><BR>dim qryShow, dspShow, qryShow2, dspShow2<BR>set dspShow = server.createobject("ADODB.Recordset")<BR>qryShow = "SELECT * FROM INFORMATION_SCHEMA.TABLES WHERE table_type = 'BASE TABLE' "<BR>dspShow = objConn.Execute(qryShow)<BR><BR>while not dspShow.EOF<BR> response.write dspShow("table_name")<BR> set dspShow2 = server.createobject("ADODB.recordset")<BR> qryShow2 = "SELECT * FROM INFORMATION_SCHEMA.COLUMNS WHERE table_name = '" & dspShow("table_name") & "'"<BR> dspShow2 = objConn.Execute(qryShow2)<BR> do until dspShow2.EOF = true<BR> response.write dspShow2("column_name")<BR> dspShow2.MoveNext()<BR> loop<BR> dspShow.MoveNext()<BR>wend<BR><BR>but it's bombing.... It's trying to say that .EOF isn't supported (??!?!) when I use .EOF throughout my site.... Can anyone help me out here? I just need to know how to get it to loop through my db and print to the screen my table name and the column names for it....<BR><BR>Of course, the second part of this is how do I display the column type? Is it simply (using the example above) 'dspShow2("column_type")'?<BR><BR>I really appreciate anyone's help with this cuz it's driving me nuts!