how to add primary key constraint at the table level what is the syntax for that expa

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • prajakta thorat
    New Member
    • Oct 2015
    • 2

    how to add primary key constraint at the table level what is the syntax for that expa

    how to add primary key constraint at the table level what is the syntax for that expalin with exampale
  • prajakta thorat
    New Member
    • Oct 2015
    • 2

    #2
    create table p_branch (
    branch_id number (10)
    ,name varchar2 (20)
    , address varchar2(30)
    , city varchar2 (20)
    , state varchar2 (20)
    , zip varchar2 (20)
    );


    alter table p_branch add constraint pk_id primary key (branch_id);

    Comment

    Working...