Schemas Editor (SQL Server)

From DBArtisan
Jump to: navigation, search

Go Up to Microsoft SQL Server Object Editors

The Schemas Editor lets you change the owner of a group and manage the objects contained in the schema.

To edit a user

  1. Open an editor on the user. For details, see Opening an Object Editor.
  2. Use the following table as a guide to understanding and modifying the settings on the tabs of this editor:
Tab Settings and tasks


Lets you modify the Owner of the schema.


For details on using this tab, see Working with Privileges and Permissions.


Displays the specific objects owned by the schema, grouped under object type folders. Optionally, you can:

Select an object and click Edit to open an object editor on that object.

Select an object and click Drop to initiate dropping the object.

DDL View

For details on using this tab, see Viewing the SQL/DDL for an Object.

3. When finished, you can submit your changes. For details, see Previewing and Submitting Object Editor Changes.