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.