Creating New Objects

You can create new databases and new database objects from the Object Explorer. You can create practically any object by selecting this object folder in the Explorer Tree view and selecting New from the popup menu.

Server Studio basic edition provides three graphical editors or wizards for databases, tables and synonyms. For other object types it uses SQL Editor to allow creation of the objects. Other graphical object editors might be available with Server Studio Add-On Modules. For more information about Server Studio extensions, see the Add-on Modules topic.

To create a new database

1. Select a database server node where you want to create a new database
2. Choose New -> Database from the popup menu or press the New Database button on the explorer toolbar.
   The Create New Database dialog box will open.
3. Enter the new database name, location, logging mode, and ANSI flag, and press OK.

To create a new table

1. Select the Tables folder where you want to create a new table. Choose New -> Table from the popup menu or press New Table on the explorer toolbar.
2. New Table dialog box will open. For additional information, see Creating a new table

To create a new synonym

1. Select a table or view where you want to create a new synonym. Choose New -> Synonym from popup menu or press New Synonym on the explorer toolbar.
2. Enter the synonym name in the New Synonym dialog box and press OK.

To create a new routine, trigger, view, or user-defined data type

1. Select the corresponding object folder in the Object Explorer. Choose New -> SQL Editor from the popup menu.
2. New SQL Editor document opens in the Document pane.
   For additional information, see Creating SQL Documents.