Online Documentation for SQL Manager for SQL server

Database objects

SQL Manager for SQL Server provides all necessary facilities for working with database objects.


Note: To start working with database objects you need to connect to database.


Database Objects:



Schema Objects:








XML Schema Collections





Non-schema Objects:


DDL Triggers

Partition Functions

Partition Schemes

Full-Text Catalogs

Symmetric Keys

Asymmetric Keys


Message Types




Remote Service Bindings



Creating Database Objects


To create a database object:

  • select the Database | New Object... main menu item;
  • select the type of object within the New Object dialog;
  • follow the steps of the wizard which guides you through the entire process of creating the object, or set the object properties using its editor - depending on the selected object type.

Note that you can also create a database object by selecting the appropriate context menu item of the DB Explorer tree or using the Ctrl+N shortcut.


To create a new object with the same properties as one of existing objects has:

Alternatively, you can right-click an object in the DB Explorer tree and select the Duplicate Object <object_name>... context menu item.


Editing Database Objects


To edit a database object:

  • select the database object in the DB Explorer tree;
  • right-click the object to call its context menu and select the Edit <object type> <object name> context menu item, or double-click the object to open it in its editor;


Renaming Database Objects


To rename a database object:

  • select the object to rename in the DB Explorer tree;
  • right-click the object and select the Rename <object type> <object name>... item from the context menu;
  • edit the object name using the Rename Object... dialog.

Note: This operation is possible for all objects except for schemas, XML Schema Collections, Assemblies, Certificates, Asymmetric Keys, Symmetric Keys, Full-Text Catalogs.



Dropping Database Objects


To drop a database object:

  • select the database object in the DB Explorer tree;
  • right-click the object to call its context menu and select the Drop <object type> <object name> context menu item;
  • confirm dropping in the dialog window.


Note: If more convenient, you can also use the following shortcuts:

Ctrl+N to create a new object;

Ctrl+O to edit the selected object;

Ctrl+R to rename the object;

Shift+Del to drop the object from the database.


When using an object editor, you can benefit from tabs. To switch between tab views, click on their respective tabs at the top of the main editor window. You can do it at any time, since the tab views are absolutely independent.


To compile a newly created or edited object, you can use the iconCompile Compile item available within the Navigation bar or Toolbar of the object editor.



See also:

Operations with database and server objects

New Object

Duplicate Object Wizard

Server Objects