Create Custom Objects

Content
Create New Custom Table Create New Custom Fields Create New Custom View Create New Custom Stored Procedures Create New Custom Functions Create New Custom Triggers Create New Custom Index Create New Custom Constraints

Aside from tables, views, and stored procedures, you can also create additional objects such as indexes, triggers, constraints, and functions. 

Below is a demonstration on how to create different custom objects using the Data Dictionary in the SQL Server environment.

 

 

 

 

 

 

 

CREATE NEW CUSTOM TABLE

1. Right Click on Table > Interprise Data Dictionary > New Custom Table.  The Table designer will load.
   
2. Create fields for your Table.  Any field applicable to the table will be treated as custom fields. A primary key is required to generate script (CRUD).
   
3. Save the Table. Enter the name for your table.
   
4. Refresh the table list in the Object Explorer. Verify that the table and column name name has a developer ID.
5. Select Customize > Data Dictionary button from the menu. The Data Dictionary form will display.

 

CREATE NEW CUSTOM FIELDS

1. Right Click on Column > Interprise Data Dictionary > New Custom Field. The Table designer will load.
   
2. Enter the new custom field name.
   
3. Save the changes. You will be prompted to enter the table name for the custom field created.
4. Refresh the table list and verify if the column has a developer ID.

 

CREATE NEW CUSTOM VIEW

1. Right Click on View > Interprise Data Dictionary > New Custom View. The view designer will load.
   
2. Select table for the view and click Add.
   
3. Refresh table list and verify if the column has a developer ID.

 

CREATE NEW CUSTOM STORED PROCEDURES

1. Right Click on Stored Procedure > Interprise Data Dictionary > New Stored Procedure. The new custom script procedure will load.
   
2. Enter the name for the new stored procedure in the template parameter box or you can enter the name directly in the script.
   
3. Execute the script.

 

CREATE NEW CUSTOM FUNCTIONS

1. Right Click on Function > Interprise Data Dictionary > New Custom Function.  The New Function script will load.
   
2. Enter the name of the new function in the template parameter box or you can enter the name directly in the script.
   
3. Execute the script.

 

CREATE NEW CUSTOM TRIGGERS

1. Right Click on Triggers > Interprise Data Dictionary > New Custom Triggers.  The new custom trigger script will load.
   
2. Enter the trigger name and table name in the template parameter box or you can enter the name directly in the script.
   

1. Execute the script.

 

CREATE NEW CUSTOM INDEX

1. Right Click on Indexes Folder > Interprise Data Dictionary > New Custom Index.  The new custom index script will load.
   
2. Enter the index name and column name or you can enter the name directly in the script.
   
3. Execute the script.
   

   User can also create Indexes using the New Index Menu in SQL and then promote it later on.

 

CREATE NEW CUSTOM CONSTRAINTS

1. Right Click on Constraint Folder > Interprise Data Dictionary > New Custom Constraint. The new custom constraint window will load.
   
2. Check constraints  box will load. Click Addto add new constraint.
   
3. Enter the constraint name.
4. Close the dialog box and save the changes.