Viewing Database Schema and Data  
 
 

You can view the structure of any ODBC or native data source.

 
 
  To view a data source schema:  
 
  1. Click the Database tab in the Resource pane.
  2. Double-click on a data source in the server pane or right-click on a server and choose Connect.
  3. Click the + sign next to an entry on the list of accessible data sources.
  4. Click the + sign next to a Table folder to view the database tables.
  5. Click the + sign next to a table to view the columns and column data types.

Views are only available in databases that support creating views or tables stored as queries.

 
 
  To view data in a table:  
 
  1. Open the data source schema in the Database Resource tab.
  2. Double-click on a table or right-click on a table and choose View Data.

You can only browse data in the data browsing window. You cannot modify data or add new records.

 
 
  Tip  
 

To insert column or table names into a page, just drag and drop the table or column into the editor. This is useful when you are building database reports.



 
 
BackUp LevelNext
 
 

allaire     AllaireDoc@allaire.com
    Copyright © 1998, Allaire Corporation. All rights reserved.