How to change the data type for the existing table

• subramanian22

  SSC Enthusiast

  Points: 113

  More actions

  April 9, 2010 at 5:03 am

  #138236

  Hi,

  I have created table

  EmployeeId bigint not null

  EmployeeName bigint

  PFNO bigint

  AFter that only i came to know that PF NO should not be null.

  How to change this type

• C.K.Shaiju

  SSCarpal Tunnel

  Points: 4228

  More actions

  April 9, 2010 at 5:14 am

  #1148960

  Hi,

  Let me clear 2 things.

  1) Is there any data in this table?

  2) EmployeeName data type is bigint or any character data type?

  Shaiju C.K.

  _____________________________________________
  One ounce of practice is more important than tonnes of dreams