You are going to create new table


New data types
You are going to create new table to be housed in the USERS01 tablespace.
The table name will be METALS and will be used to store a description of various metals. The following offers some additional direction on how the table should be created.

* The table shall have a primary key called METALS_ID.
* An inline primary key constraint shall be defined. The constraint name shall be METALS_ID_PK shall be used.
* An addition column of METAL_DESCRIPTION shall be added to the table definition.
* A unique constraint on METAL_DESCRIPTION shall be added to the table definition. The constraint name shall be METAL_DESC_UK shall be used.
Can you write and execute the SQL commands.

Request for Solution File

Ask an Expert for Answer!!
PL-SQL Programming: You are going to create new table
Reference No:- TGS0145924

Expected delivery within 24 Hours