Home Forums SQL Server 7,2000 T-SQL problem with naming default constraint and using it while adding a not null column RE: problem with naming default constraint and using it while adding a not null column

  • November 5, 2007 at 2:32 am

    #748136

    ALTER TABLE Staff ADD StaffCode varchar(10) NOT NULL CONSTRAINT Staff_StaffCode_df DEFAULT(' ');

    --Ramesh