Using a CREATE TABLE statement: create a table with primary key : Create Primary Key « Constraints « Oracle PL / SQL

1. Oracle PL / SQL
2. Constraints
3. Create Primary Key

Using a CREATE TABLE statement: create a table with primary key

  


SQL>
SQL> --Using a CREATE TABLE statement
SQL>
SQL> CREATE TABLE supplier
  2  (  supplier_id     numeric(10)     not null,
  3     supplier_name   varchar2(50)    not null,
  4     contact_name    varchar2(50),
  5     CONSTRAINT supplier_pk PRIMARY KEY (supplier_id)
  6  );

Table created.

SQL>
SQL> desc supplier;
 Name                           Null?    Type
 ------------------------------ -------- --------------

 SUPPLIER_ID                    NOT NULL NUMBER(10)
 SUPPLIER_NAME                  NOT NULL VARCHAR2(50)
 CONTACT_NAME                    VARCHAR2(50)

SQL>
SQL> drop table supplier;

Table dropped.

SQL>
SQL>
           
         
    
  

Related examples in the same category