Using ColdFusion Studio
Chapter 7 :  Accessing ColdFusion Data Sources

Viewing Data Sources

Once a data source is registered, you can work with it in Studio.

To open a data source:

1. Open the Database tab and select a server from the dropdown list in the top pane.

   Accessing a large database on a remote servers may take a few moments.

2. Click the plus sign (+) next to a data source name to expand the tree.
3. Click the plus sign (+) next to Tables to view the database schema.
4. Click the plus sign (+) next to a table name to view the column definitions.
5. Double-click on a table name to view the records in that table.

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

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

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.

Copyright © 1999, Allaire Corporation. All rights reserved.