Can't Create primarykey

• Subu

  Say Hey Kid

  Points: 680

  More actions

  October 30, 2007 at 2:24 am

  #199519

  alter table dept

  add constraint PK_deptno primary key (deptno)

  I am getting this error

  Cannot define PRIMARY KEY constraint on nullable column in table 'dept'.

  any body plz help me

  Thanks & Regards

  subu

• Johannes Fourie

  Default port

  Points: 1470

  More actions

  October 30, 2007 at 2:28 am

  #746507

  Alter that column, make it NOT NULL