Query Analizer con Asp?

[posman]

Tambien podrias puedes mostrar el nombre de cada columna

SQL server

Código:

adSchemaTables = 20
adSchemaColumns = 4
set rs = conexion.OpenSchema(adSchemaTables,Array(null,null,null,"TABLE"))
do while not rs.eof
    tabla = rs("table_name")
    response.write "tabla = " & tabla & "<br>"
    set campos = conexion.OpenSchema(adSchemaColumns,Array(null,null,tabla,null))
    do while not campos.eof
        response.write campos("column_name") & ","
        campos.movenext
    loop
    response.write "<br><br>"
    rs.movenext
loop

ORACLE

Código:

select * from dba_tab_columns where table_name = 'Nombre_de_la_tabla'