|
Normalized DCT (Preview) |
  
|
|
Normalized DCT (Preview) |
|
PREVIEW your SQL Normalized Dictionary (how it will be after applying your SQL normalization options)
Export this to Predefined Formats with the "Send To" button
"Toggle dsp." button to display only the SQL Reserved Words found and displayed in red (change them in EIP mode)
Any AutoNumber KEY on several columns (illegal in SQL) - DMC will use IDENTITY on the FIRST column ONLY
Any GROUPED Date and Time Columns will be displayed in orange
This STEP allows you to review how your DCT will be after applying your SQL normalization options
Click on "Proceed" to carry on to the Next Step (Tables and destination SQL DB SELECTION)
NO WORK is done in all these steps (ONLY displays)
Changing in Edit in Place mode your SQL Reserved Words
Click in any column displayed in red to change the Column Name - DMC will store this New Name and swap it throughout your application and code
(both in Columns and any Key using those Columns)
When all are modified the DISPLAY will toggle automaticaly back to the FULL Dictionary
A List of the SQL Reserved Words used in your Dictionary will be displayed for you to change them in DCT (if you prefer)
At the bottom of this list you will find another list - all DUPLICATED KEY NAMES
(this will aloow you to modify your DCT yourself if you want to)
AutoNumber Keys (with errors) and Grouped Date and Time Columns
