Macromedia dreamweaver 8-using dreamweaver User Manual

656

Chapter 30:  Optimizing the Workspace for Visual Development

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.

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

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.

Viewing live data in Design view 

Dreamweaver can display the dynamic content of a page while you work on the page in 
Design view. For more information on Design view, see 

. 

To view dynamic content in Design view:

1.

Make sure Dreamweaver is properly configured to display live data. 

For more information, see 

.

2.

Select View > Live Data.

Dreamweaver displays the page in Design view complete with dynamic content.

NO

T

E

Dreamweaver looks at the ColdFusion server you defined for the current site. (See 

.)