test 1

create table works_on (
emp_no int,
project_no int,
job char(40) not null,
enter_date date,
)

alter table emp add constraint unique_fname unique(emp_fname)

alter table works_on add constraint default_date default getdate() for enter_date

alter table name add constraint limit_budget check(budget > 0 and budget < 250000)

alter table emp drop unique_fname

insert ....,

exec sp_rename 'people.emp_fname', 'emp_surname', 'COLUMN';

update people set emp_surname = 'Bond' where emp_name = 'Elsa'

update project set project_name = 'kupa' where project_no > 3 and project_no < 5,