Viewing information about database objects

The Connections section in Yandex WebSQL provides information about database objects. You can view information about the following:

• Schema
• Table
• View

Viewing information about a schemaViewing information about a schema

1. Under Connections, select the connection and DB.
2. Select the schema.
3. To the right of the schema name, click .

This will open a panel with information about the schema name and its sequences, if any.

Viewing information about a tableViewing information about a table

1. Under Connections, select the connection and DB.
2. In the Tables group, select a table.
3. To the right of the table name, click .

This will open a panel with information about the table name, size, and approximate number of table rows. You can also get the following information about table columns:

• Column name.
• Data type.
• Whether or not the column is a primary key.
• Whether or not the column is a foreign key.
• Whether or not the column is nullable.

If the table contains indexes or triggers, the same panel will display information about columns and indexing types, as well as trigger events.

Viewing information about a viewViewing information about a view

1. Under Connections, select the connection and DB.
2. In the Views group, select the view.
3. To the right of the view name, click .

This will open a panel with information about the view name and columns:

• Column name.
• Data type.
• Whether or not the column is nullable.