Use the following options and tabs in the Table Editor to add a new table or modify the properties of an existing table. Available options and tabs will vary based upon your target DBMS and the model properties you select in the Model Editor.
PreviousPositions the editor on the previous table in the Navigation Grid.
NextPositions the editor on the next table in the Navigation Grid.
SortSorts the tables by alphabetic or reverse alphabetic order. You select the method you want using the drop-down menu that opens after you click the Sort button. Visual cues are provided for how the table list is currently sorted:
Specifies that the table list is sorted in alphabetic order.
Specifies that the table list is sorted in reverse alphabetic order.
NewCreates a new table that becomes the current object in the editor.
DeleteDeletes the selected table.
DB SyncOpens the DB Sync wizard so you can perform a database level compare of objects in the current model with matching objects in another model.
HelpOpens online help for the editor.
Lets you filter a very large list of tables in the Navigation Grid to quickly locate the table for which you need to view or define properties.
Specifies the physical name of the table. You can change the physical name of the table in this field.
Specifies the schema of the database to which the table belongs. You select the schema from the drop-down list.
This property applies only to SQL Server target database. It specifies the type of the SQL Server table and has three possible values:
Disk Based
Memory Optimized (applicable to SQL Server version 2014 and above)
File (applicable SQL Server 2012 and above)
Specifies whether the table is suppressed from a logical model and appears in a physical model only.
Generates SQL during forward engineering. Clear the check box if you do not want to generate SQL.
Specify dimensional modeling table roles and document how to update information in the data warehouse if the table has a dimension role.
Note: This tab is only available if you selected the Is Dimensional check box in the Model Editor.
Document data movement rules for a table.
Note: This tab is only available if you selected the Data Movement check box in the Model Editor.
View and modify physical storage properties for a table and associate tables to predefined physical storage devices. Depending on your target DBMS, you may have additional database-specific table properties that can be set.
Define partition columns for a table.
Define data compression options for a table. The data compression types available for a table are None, Row, and Page.
Specify the validation rules to attach to a table.
Lets you define table permissions.
Lets you enter any comments that you want to associate with the table.
Lets you enter sizing information, including growth estimates, for a table.
Note: Use the Volumetrics dialog to view and report table and database size calculations.
Lets you preview the forward engineering script of the selected table and the corresponding comments, partitions, and physical storage.
Work with style sheets, which are used to format the font and other graphical themes used in the display of the table.
Specify the icon style to use for the table.
Specify the order of DDL generation.
View where the table is used within the model.
Lets you enter user-defined property values for a table.
View table history information and view or edit user notes.
Note: When you select a physical storage object in which to store a table, the default or current parameters for that object appear with the table. Therefore, when you view a table in the Table Editor, you can see the associated table name and the physical object in which the table is stored, and you can modify the parameters for that physical storage object. You can also increase or decrease the space available for the selected table, create space to store additional tables in the same physical object, or modify the size of storage objects as they are created.
|
Copyright © 2017 erwin Inc.
All rights reserved.
|
|