Previous | Page 2 of 3 | Next

Create a New DWR_DRUG_ITEM Reference Table

Define the Primary Key, Unique Key, and Other Indexes

Now that the table is defined, Tom continues using SQL Developer to define the table's primary key, unique key, and other indexes.

Tom decides he can define a unique key DRUG_ITEM_NBR because MeddWebb's drugs have been assigned unique numberings.

the SQL script that creates the primary key, unique key, and other indexes.

 

Previous | Page 2 of 3 | Next