-
Relationships Wizard
This wizard lets you modify relationships constraints on all tables.
Details...
Figure: Choose your script creation options
-
"Enforce Relationship For Insert And Update" - Select this means someone can't add or change records
to a related table if there is no associated record in the primary table.
-
"Check Existing Data on Creation" - Select this option to check existing data when you create a relationship
if the foreign key constraint should apply to existing data as well as to new data.
-
"Cascade Update Related Fields" - Specifies that if an attempt is made to update a key value in a row, where
the key value is referenced by foreign keys in existing rows in other tables, all the values that make up the
foreign key are also updated to the new value specified for the key.
-
"Exclude Relationship from Replication" - Select this option will add a NOT FOR REPLICATION clause when creating relationship.
Details...
-
"Cascade Delete Realated Fields" - Specifies that if an attempt is made to delete a row with a key referenced
by foreign keys in existing rows in other tables, all rows that contain those foreign keys are also deleted.
This
could be very dangerouse.
-
Primary Key Wizard
This Wizard can help to optimize SQL Server performance by analyzing the data
in a table and recommending candidate columns for a Primary Key. It will
generate a SQL script to add or change the Primary Key for the selected
column.
Details...
Figure: Select the table to add Primary Key
Figure: Pick the candidate column to create Primary Key
How to choose an appropriate Primary Key?
Figure: Review the options for creating Primary Key
-
Clustered Index Wizard
This Wizard can help to optimize SQL Server performance by analyzing the data
in a table and recommending candidate columns for a Clustered Index. It will
generate a SQL script to add or change the Clustered Index for the selected
column.
Details...
Figure: Select table to add Clustered Index
Figure: Pick candidate columns to create Clustered Index
More info about Clustered Index
Figure: Review the options for creating Clustered Index
-
Validate Foreign Key
columns Wizard
Many SQL Server database programmers use standard naming conventions such as ID
in the column name to indicate a relationship with another table. i.e.
ClientID. This wizard identifies columns ending with 'ID' which are missing
FOREIGN KEY constraints and suggests relationships, where possible.
Details...
Figure: The Foreign Key Relationship Wizard
Figure: Choose Foreign Key columns
Figure: Choose script creation options More info...
-
LastModified Column Wizard
Every table should have a LastModified column to record the last modified time of each row,
our script will add a trigger with the columns to record the time.
Details...
Figure: Choose the tables that you want to add LastModified column
This will add the column into your tables as well as create a trigger to update this column automatically.
-
Timestamp Wizard
The Timestamp Wizard will add Timestamp columns to any or all tables that do
not have a Timestamp column.
Details...
Figure: Choose the tables that you want to add Timestamp column