Object Browser is part of the SQL Developer front end provided to create, view and modify database objects through a GUI. The object browser screen is seen below:
To create a table:To create a table click on the Create button and select Table option. The following page appears:
Enter table name and field names with data type.
Click Next> and enter primary key information:
Select populate from a new sequence and select primary key column. So, while creating the table the system also creates a new sequence and a before insert trigger to polulate the primary key column from the sequence.
The following two pages request you to enter foreign key and check constraints. Then finish to create the table.
No comments:
Post a Comment