Schemas Editor (SQL Server)
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
- Open an editor on the user. For details, see Opening an Object Editor.
- Use the following table as a guide to understanding and modifying the settings on the tabs of this editor:
Tab | Settings and tasks | |
---|---|---|
Properties |
Lets you modify the Owner of the schema. | |
Permissions |
For details on using this tab, see Working with Privileges and Permissions. | |
Objects |
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.