<% '============================================================== ' TableEditoR 0.81 Beta ' http://www.2enetworx.com/dev/projects/tableeditor.asp '-------------------------------------------------------------- ' File: te_showschema.asp ' Description: Displays the database schema ' Initiated By Hakan Eskici on Nov 01, 2000 '-------------------------------------------------------------- ' Copyright (c) 2002, 2eNetWorX/dev. ' ' TableEditoR is distributed with General Public License. ' Any derivatives of this software must remain OpenSource and ' must be distributed at no charge. ' (See license.txt for additional information) ' ' See Credits.txt for the list of contributors. ' ' Change Log: '-------------------------------------------------------------- ' # May 30, 2002 by Rami Kattan ' Table format is like other TE tables :) '============================================================== %>
Home » Connections » Schema List <% if bProtected then response.write session("teFullName") response.write " (logout)" end if %>

Schema : <% =sTitle %>

> <% lConnID = request.querystring("cid") OpenRS arrConn(lConnID) sub ShowSchema(sTitle, iSchema) set rsX = conn.openSchema(iSchema) ' response.write "
" response.write "" for each fld in rsX.fields response.write "" next response.write "" do while not rsX.eof response.write "" for each fld in rsX.fields response.write "" next response.write "" rsX.MoveNext loop response.write "
" & fld.name & "
" & rsX(fld.name) & " 



" rsX.close end sub ShowSchema "Tables", 20 %>