Creating a Schema


Visually Creating a Schema

To visually create a schema, in the Object Explorer, expand the database:

Object Explorer - New Schema

Object Explorer - New Schema

This would open the Schema - New dialog box. In the Schema Name text box, enter a one-word name. Here is an example:


After providing a name, you can click OK.

Creating a Schema

The basic formula to create a schema is:

CREATE SCHEMA schema_name_clause [ <schema_element> [ ...n ] ]

Here is an example:

1> CREATE SCHEMA PrivateListing;
2> GO

  Copyright © 2008-2013 FunctionX