About the Schema Navigator

Provides a tree control that displays the structure and details of the schema (for example, keyspaces, tables) for the current connection.

DataStax DevCenter is compatible with DataStax Enterprise (DSE) versions up to 5.0.

The Schema Navigator provides a tree control that displays the structure and details of the schema (for example, keyspaces, tables) for the current connection.

When DevCenter runs against a DataStax Enterprise cluster, the Schema Navigator displays User-defined functions, User-defined aggregates, User-defined types, and Materialized Views. The Schema Navigator only show nodes representing elements that are supported for the active cluster.

It displays the schema for the current active tab in the Query Editor pane.

Schema navigator contextual menu 

Right-clicking in the Schema Navigator pane (with no node selected) displays a contextual menu. The menu items are:
  • New Keyspace: displays the New Keyspace wizard
  • New Table: displays the New Table wizard

Keyspace node contextual menu 

Right-clicking on a keyspace node in the Schema Navigator pane on a selected node displays a contextual menu. The menu items are:
New Keyspace
displays the New Keyspace wizard
New Table
displays the New Table wizard
New Index
displays the New Index wizard
New User Type
displays the New User-defined Type wizard
New Materialized View
displays the New Materialized View wizard
Clone Keyspace
displays the New Keyspace wizard with values of fields set to the selected keyspace's settings
Drop Keyspace
displays the Drop Keyspace dialog
Edit Keyspace
displays the Edit Keyspace wizard (which contains the same fields as the New Keyspace wizard) for editing the selected keyspace's settings
Note: If one of the system keyspace nodes (system, system_auth, system_distributed, etc.) is selected, then only the New Keyspace is available in the contextual menu, because it is not recommended to change this keyspaces.

Table node contextual menu 

Right-clicking on a table node in the Schema Navigator pane on a selected node displays a contextual menu. The menu items are:
New Keyspace
displays the New Keyspace wizard
New Table
displays the New Table wizard
New Index
displays the New Index wizard
New User Type
displays the New User-defined Type wizard
New Materialized View
displays the New Materialized View wizard
Clone Table
displays the New Table wizard with values of fields set to the selected table's settings
Drop Table
displays the Drop Table dialog
Edit Table
displays the Edit Table wizard (which contains the same fields as the New Table wizard) for editing the selected table's settings
When editing a table, only primary key column names can be changed. Likewise, when editing a table's column, only non-primary key columns may have their types changed.

User-defined type node contextual menu 

Right-clicking on a user-defined type node in the Schema Navigator pane on a selected node displays a contextual menu. The menu items are:
New Keyspace
displays the New Keyspace wizard
New Table
displays the New Table wizard
New Index
displays the New Index wizard
New User Type
displays the New User-defined Type wizard
New Materialized View
displays the New Materialized View wizard
Drop User Type
displays the Drop User Type dialog

Also, user-defined types can be dropped by selecting the node and selecting Drop Function

User-defined function node contextual menu 

Right-clicking on a user-defined type node in the Schema Navigator pane on a selected node displays a contextual menu. The menu items are:
New Keyspace
displays the New Keyspace wizard
New Table
displays the New Table wizard
New Index
displays the New Index wizard
New User Type
displays the New User-defined Type wizard
New Materialized View
displays the New Materialized View wizard
Drop Function
displays the Drop Function dialog

Also, user-defined types can be dropped by selecting the node and selecting Drop Function

Materialized view node contextual menu 

Right-clicking on a materialized view node in the Schema Navigator pane on a selected node displays a contextual menu. The menu items are:
New Keyspace
displays the New Keyspace wizard
New Table
displays the New Table wizard
New Index
displays the New Index wizard
New User Type
displays the New User-defined Type wizard
New Materialized View
displays the New Materialized View wizard
Clone View
displays the New View wizard with values of fields set to the selected table's settings
Drop View
displays the Drop View dialog
Edit View
displays the Edit View wizard (which contains the same fields as the New View wizard) for editing the selected table's settings

Wizards resynchronize with database after partial failure 

If more than one statement is generated (typically in Edit Keyspace or Edit Table wizards), a statement may fail although previous ones succeeded. In this situation, the wizard dialog is kept open, and its contents are resynchronized with the database.