Viewing your database within Dreamweaver

After connecting to your database, you can view its structure and data within Dreamweaver.

To view the database:

1. Open the Databases panel (Window > Databases).

   Dreamweaver populates the Databases panel with all the databases for which connections have been created. If you’re developing a ColdFusion site, Dreamweaver populates the panel with all the databases for which data sources have been defined in ColdFusion Administrator.

   NOTE

   Dreamweaver looks at the ColdFusion server you defined for the current site. (See Specifying where dynamic pages can be processed.)

   If no database appears in the panel, you must create a database connection. For more information, see Connecting to a database.

2. To display the tables, stored procedures, and views in the database, click the Plus (+) sign beside a connection in the list.
3. To display the columns in the table, click a table name.

   The columns icons reflect the data type and also indicate the primary key.

4. To view the data in a table, right-click (Windows) or Control-click (Macintosh) the table name in the list and select View Data from the pop-up menu.

   Dreamweaver also identifies the primary key of each table, and the data types of each column.