Viewing your database within Dreamweaver

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 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.

Getting Started with Dreamweaver
Dreamweaver Basics
Working with Dreamweaver Sites
Laying Out Pages
Adding Content to Pages
Working with Page Code
Preparing to Build Dynamic Sites
Making Pages Dynamic
Defining Sources of Dynamic Content
Developing Applications Rapidly