Perform operations on database object nodes

Last modified: July 8, 2025

Database Explorer allows you to create database objects and view, export, import, or filter data using the shortcut menu of the database object nodes.

Tables node

In Database Explorer, right-click the Tables node and select the required command from the shortcut menu.

Perform operations on the Tables node

Create a table

To create a table:

1. In Database Explorer, right-click the Tables node and select New Table.

2. In the Table Editor that opens, specify the table name, schema it belongs to, columns and their properties, and data. You can also add triggers or indexes and preview the generated script before saving the table.

For more information about settings you can enter to create a table, see How to work with Table Editor.

3. On the Table Editor toolbar, select Apply Changes to save the table.

Views node

In Database Explorer, right-click the Views node and select the required command from the shortcut menu.

Perform operations on the Views node

Create a view

To create a view:

1. In Database Explorer, right-click the Views node and select New View.

2. In View Editor that opens, do the following:

  • Under Query Text, enter the view name, select the schema it belongs to, enter the query, and select view options.
  • Optional: Under Query Design, build the view query on the diagram.
  • Optional: Under Indexes, add indexes for the view.
  • Optional: Under Statistics, set up statistics.
  • Optional: Under Triggers, add triggers.
  • Optional: Under T-SQL, preview the generated script.

3. On the View Editor toolbar, select Apply Changes to save the view.

Synonyms node

In Database Explorer, right-click the Synonyms node and select the required command from the shortcut menu.

Perform operations on the Synonyms node

Create a synonym

To create a synonym:

1. In Database Explorer, right-click the Synonyms node and select New Synonym.

2. In a SQL document that opens, enter the CREATE SYNONYM statement.

3. At the bottom of the SQL document, select Apply Changes to save the synonym.

Procedures node

In Database Explorer, right-click the Procedures node and select the required command from the shortcut menu.

Perform operations on the Procedures node

Create a stored procedure

1. In Database Explorer, right-click the Procedures node and select New Procedure.

2. In a SQL document that opens, enter the CREATE PROCEDURE statement.

3. At the bottom of the SQL document, select Apply Changes to save the stored procedure.

Functions node

In Database Explorer, right-click the Functions node and select the required command from the shortcut menu.

Perform operations on the Functions node

Create a table-valued function

To create a table-valued function:

1. In Database Explorer, right-click the Functions or Table-valued Function node and select New Table-valued Function.

2. In a SQL document that opens, enter the CREATE FUNCTION statement.

3. At the bottom of the SQL document, select Apply Changes to save the function.

Create a scalar function

To create a scalar function:

1. In Database Explorer, right-click the Functions or Scalar Function node and select New Scalar Function.

2. In a SQL document that opens, enter the CREATE FUNCTION statement.

3. At the bottom of the SQL document, select Apply Changes to save the function.

Create an aggregate function

To create an aggregate function:

1. In Database Explorer, right-click the Functions or Aggregate Function node and select New Aggregate Function.

2. In a SQL document that opens, enter the CREATE AGGREGATE statement.

3. At the bottom of the SQL document, select Apply Changes to save the function.

Database Triggers node

In Database Explorer, right-click the Database Triggers node and select the required command from the shortcut menu.

Perform operations on the Database Triggers node

Create a DDL trigger

To create a trigger:

1. In Database Explorer, right-click the Database Triggers node and select New DDL Trigger.

2. In a SQL document that opens, enter the CREATE TRIGGER statement.

3. At the bottom of the SQL document, select Apply Changes to save the trigger.

Enable all triggers

To enable all triggers, right-click the Database Triggers node and select Enable All.

Deactivate all triggers

To deactivate all triggers, right-click the Database Triggers node and select Disable All.

Sequences node

In Database Explorer, right-click the Sequences node and select the required command from the shortcut menu.

Perform operations on the Sequences node

Create a sequence

To create a sequence:

1. In Database Explorer, right-click the Sequences node and select New Sequence.

2. In a SQL document that opens, enter the CREATE SEQUENCE statement.

3. At the bottom of the SQL document, select Apply Changes to save the sequence.

Shortcut menu commands

The following table briefly explains the other shortcut commands available when you right-click an object node in Database Explorer. The table includes each command description and its availability for different database object types.

Command Description Available for database object nodes
Tasks > Export Data Opens the Data Export wizard to export data to a file with the supported file extension. TablesViews
Tasks > Import Data Opens the Data Import wizard to import data from a file into a database. Tables
Filter Opens the Filter Settings dialog to filter which database objects appear in Database Explorer. TablesViewsSynonymsProceduresDatabase TriggersSequencesAssemblies (Rules and Defaults)External resourcesService BrokerStorageSecurity
Show Details Opens Object Viewer to view object details. TablesViewsSynonymsProgrammabilityExternal resourcesService BrokerStorageSecurity
Refresh Updates the database object node to reflect the latest changes made in the database. Alternatively, press F5. TablesViewsSynonymsProgrammabilityExternal resourcesService BrokerStorageSecurity
Unit Test > Add New Test Opens the Add New Test dialog to create a unit test in the database. ProgrammabilityProcedures
Unit Test > View Test List Opens the Test List Manager to view unit tests in the database. ProgrammabilityProcedures
Unit Test > Run All Tests Runs all tests for the selected database. ProgrammabilityProcedures
Find in Security Manager Opens Security Manager with the highlighted database object. UsersRolesApplication RolesSchemas