Schemas

For each database, you can define the set of schemas you want to work with. The screen presents a list with the following information:

Column name Description
Name The schema name.
Tables # The number of objects that are present in the schema.
Schemas

Add schema

On the right-hand top corner there is a button ADD SCHEMA. When you click on it, you will be redirected to the screen where the following values are to be entered:

Parameter Required Default value Description
Schema name Yes   The new schema name. It has to be unique in the context of the database. By default, there is at least dbo database schema.
Comment No   The optional comment text.
Add schema

Edit schema

The screen allows editing the selected schema by clicking on EDIT button. It has the same fields as in add schema screen.

Edit schema

Delete schema

When you click on DELETE button, the summary screen appears with information about the tables and views in the selected schema:

Column name Description
Type The object type, it can have two values: view or table.
Schema The object schema name.
Virtual name The object virtual name.
Physical name The object physical name.
#columns Number of the columns in the object.

When you click again the DELETE button, then all contained virtual tables and views will be permanently removed.

Delete schema

Tables & views

This screen represents a summary of the tables and views within the schema:

Column name Description
Virtual table name The object virtual name.
Type The object type, it can have two values: view or table.
Source table name The full source table name with the database name and the schema name.
Columns # Number of the columns in the object.

When you click on the row with the object you will be redirected to the Columns section of the selected Managing views or Managing tables.

Tables and views

Access rights

Please go to the Access rights section for general information about access rights. Schema access rights are listed below:

Access right Description
Alter Confers to the grantee the ability to alter schema, table or view access rights.
Alter schema Confers to the grantee the ability to change schema attributes.
Control Confers to the grantee the ability to alter, delete, insert, select and view definition access rights.
Control schema Confers to the grantee the ability to view definition, alter schema, alter view, control table, create table, control view and create view access rights.
Create table Confers to the grantee the ability to create a table.
Create view Confers to the grantee the ability to create a view.
Delete Confers to the grantee the ability to delete the data.
Insert Confers to the grantee the ability to insert the data.
Select Confers to the grantee the ability to select the data.
Update Confers to the grantee the ability to update the data.
View definition Enables the grantee to access schema metadata.

Business terms

Please refer to the Business terms section.