The
University
of
Vermont

 

SQL Navigation. 

  •  Sometimes the hardest part of digging up the treasure is finding where it is buried.
    • ER Diagrams
    • Database schematics
    • Drill down from screens.
      • Use Metadata


      Entity-Relationship Diagrams:


      Database schematics:

        These are also a pictoral representation of the database, usually less formal than an ER diagram, coming in many shapes and sizes.


      Drill down from screens:

        Using this technique, you find an online screen that shows some of the information you are interested in, and if you are lucky enough, the "field level help" wil tell you where in the database the information is stored. Try PF1 in BANNER. Or, point a techy at the screen and say "This right here, that's what I want, where is it?".


      Metadata:

        Try "SET HEADING OFF; SELECT TABLE_NAME FROM ALL_TABLES;"
        then try "SELECT TABLE_NAME FROM ALL_TAB_COMMENTS 
                     WHERE UPPER(COMMENTS) LIKE '%COURSE%';"
        or "SELECT COLUMN_NAME FROM ALL_COL_COMMENTS
                      WHERE .......
    Brought to you through the courtesy of Computing and Information Technology, University of Vermont. Copyright © 1996 The University of Vermont and others. All rights reserved.

    The University supports both institutional and personal web pages. The views expressed on personal web pages are strictly those of the author, and are not reviewed or approved by the University of Vermont

    Send questions and comments to  Keith.Kennedy@uvm.edu

    Read the Webmaster's Policies.
    Last page update: November 11, 1998