|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Viewing Database Schema and Data
|
|
|
|
You can view the structure of any ODBC or native data source.
|
|
|
|
To view a data source schema:
|
|
|
- Click the Database tab in the Resource pane.
- Double-click on a data source in the server pane or right-click on a server and choose Connect.
- Click the + sign next to an entry on the list of accessible data sources.
- Click the + sign next to a Table folder to view the database tables.
- 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:
|
|
|
- Open the data source schema in the Database Resource tab.
- 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.
|
|
|
  
|
|
|
AllaireDoc@allaire.com
Copyright © 1998, Allaire Corporation. All rights reserved.
|