Creating and Editing Database Schemas
Contents
Go Up to Creating and Editing Database Dependent Objects
A database schema is a collection of unique objects in a namespace. Schemas allow you to group tables and other related objects together, such as a table and an index. Once the schema has been defined you can
The following database platforms support Schemas:
- IBM DB2 for LUW 5.x, 6.x, 7.x, 8.x, 9.x, and 10.x
- Microsoft SQL Server 2005 - 2014
- The Database Schema Wizard and Database Schema Editor share the same options, except for Attachment Bindings options which are present only in the editor.
Create a Database Schema
- In the Data Model Explorer, expand the Physical Main Model, right-click the Schema node and then click New Database Schema.
- Complete the Database Schema Wizard and then click Finish to create the database schema.
- Once you have created the schema, you can edit it by right-clicking the schema you want to change, and then selecting Edit Schema.
Object Privilege page/tab
Sets access roles and user permissions for the schema. Keep in mind that the more specific permissions are, the more time you may have to spend maintaining and updating them. The Roles and Users must be previously assigned to appear in the Sequence Editor. For more information, see Granting and Revoking Permissions to Modify Database Objects.
Definition page/tab
Enter or edit a definition for the schema. If the target database supports it, ER/Studio Data Architect adds this definition as a comment when generating SQL code.
DDL page/tab
Displays the CREATE SCHEMA statement needed to build the schema. ER/Studio Data Architect uses the platform-specific parser of the model's selected database platform to generate the tablespace.
Attachment Bindings tab
Bind an external piece of information, or attachment to the schema. You can also remove an attachment from an object, override an attachment binding's default value, or change the position of a bound attachment. To override the value of the attachment you have moved to the Selected Attachments grid, double-click the Value field of the target attachment. ER/Studio Data Architect opens the Value Override Editor or a list depending on the attachment datatype. Attachments are created in the Attachments folder of the Data Dictionary. For more information, see Attaching External Documents to the Data Model.