Table

Topic updated 12-6-2007

The Table Designer is used to view and modify the properties of tables and Views. The Project Explorer uses different icons for tables icon_Table and Views icon_View.

The lower half of the Table Designer lists the Columns, Relations and Keys that belong to the table or view. These can be double clicked to open their designers. Click New Column to add a Column, New Relation to add a Relation and New Key to add a Key to the entity, while opening the designer for the added object.

The <Filter> textboxes can be used to make a visual selection in the list. When a few characters are typed in these textboxes, listed objects with names that match that pattern will be highlighted.

TableDesigner

 

General table properties

Name
The Name property can be different from the DB Name, the actual entity name in the database. Sometimes this is necessary because the database name is in conflict with .NET naming conventions.

Alias
The Alias can be useful in the BO-Layer projects, to use shorter names for object naming. Click the button next to the alias textbox to have an alias generated for you, this takes into account the aliases that have already been used.

Description
Used only for internal documentation purposes.

Category
You can assign all your Datastore Entities to categories that you define yourself. This is useful when working with a Datastore that contains many entities. You can Change Tree Grouping to Group By Category for grouped display in the Project Explorer. In the Category textbox, you can type a new category that you want to use, or you can select a category that you created earlier from the dropdown list.

DB Name
The literal name of the entity in the database. For some database this will be case-sensitive.

DB Owner
This indicates the database object owner. The database owner name is always prepended to the entity name in SQL statements generated by GenWise.