Restricting database information displayed in Dreamweaver

Advanced users of large database systems like Oracle should restrict the number of database items retrieved and displayed by Dreamweaver at design time. An Oracle database may contain items that Dreamweaver cannot process at design time. You can create a schema in Oracle and use it in Dreamweaver to filter out unnecessary items at design time.

Other users may benefit from restricting the amount of information Dreamweaver retrieves at design time. Some databases contain dozens or even hundreds of tables, and you might not want Dreamweaver to list them all while you work. A schema or catalog can restrict the number of database items Dreamweaver gets at design time.

You must create a schema or catalog in your database system before you can apply it in Dreamweaver. Consult your database system documentation or your system administrator.

You cannot apply a schema or catalog in Dreamweaver if you’re developing a ColdFusion application.

To apply a schema or catalog in Dreamweaver to an application other than ColdFusion:

1. Open a dynamic page in Dreamweaver; then open the Databases panel (Window > Databases).

   If the database connection already exists, a list of connections appears in the panel.

2. Right-click (Windows) or Control-click (Macintosh) the connection, and select Edit Connection from the pop-up menu. The dialog box appropriate for the connection appears.

   If the connection does not exist, click the Plus (+) button at the top of the panel and create it. For more information, see Connecting to a database.

3. In the dialog box for the connection, click Advanced.

   The Restrict dialog box appears.

4. Specify your schema or catalog.
5. Click OK.