Creating a Standard or Raw type table

About this task

This topic explains the steps to create a standard or raw table.

Procedure

  1. Enter mandatory fields such as Table Name and Table Owner.
  2. Select Standard(default) or Raw type from Table Type dropdown.
  3. Click on Add Column for adding columns to the table.
  4. To cancel Create Table operation click on Cancel button.
  5. Next button will be enabled after user is done adding columns to the table.
  6. By clicking on Add Columns button pop up will appear to add column details.
  7. Enter values for all mandatory fields(*).
  8. To give a constraint on any column, click on Column Check Constraint checkbox.
  9. Multiple columns can be added using the same pop up.
  10. To go back to the main screen, click on Close button or cross icon in the upper right corner.
  11. Once columns are added, user can view, edit, delete any of the columns.
  12. Table level constraint can be added on this screen by clicking on Table Check Constraint checkbox.
  13. Once details related to the columns are finalized, clicking on Next button takes user to add constraint page.
  14. This screen is for adding a constraint like primary key, foreign key, unique key to a table.
  15. To assign primary key to a table, give Primary Key Name & select Primary Key Columns.
  16. To add Foreign key constraint, click on Add button in Foreign key section.
  17. To assign a foreign key for a table, give Foreign Key Name & map Referenced Column with Table Column.
  18. To add a Unique key constraint, click on Add button in Unique key section.
  19. To assign a unique key for a table, give Unique Key Name & select Available Columns from the list. This will enable the Add button.
  20. Once constraints are added user can go to either View SQLor Advance Table Options
  21. Modify advance table level options using the screen given below. For example, changing lock mode, storage scheme, update statistics, etc.
  22. Once advance table option are set, click on View Query & Create button to view SQL query for creating the table.
  23. After clicking on View Query & Create button from Advance Table Options or on View SQLbutton from Add Constraints screen, user will be able to view 'create table' query as shown in the screen given below.
  24. Click Create button to create the table.
  25. If table is created successfully, information status message will be shown and user will be taken back to Schema Manager page.
  26. If table creation fails, error status message is displayed and all the create table related queries will be rolled back.
  27. To go back to modify any properties click Back button and to cancel the operation of create table click on Cancel button.