File Manager: SQL

Zend Studio allows you to view the database structure of an SQL server.

To view the database structure of an SQL server:

1. Open the SQL tab of the File Manager. The SQL server tree displays a list of all SQL servers currently listed.

SQL Server Tree

2. Click the server whose database structure you wish to view.  

3. Expand the server node to see a list of the databases stored on that server.  

Viewing the Schema Structure of the Database

Some of the supported servers display schemas as part of their relational model.

To view the schema structure of a database stored on an SQL server:

1. From the SQL tab, click the server that contains the database whose schema you wish to view.  

2. Expand Databases. Studio displays a list of all databases currently stored on the selected server.  

3. Double-click the database whose schema structure you wish to view.
   Studio displays the schema structure for the selected database.