ALTER TABLE Add adds multiple field foreign KEY constraints

/* CREATE TABLE and set PRIMARY key */creation table
 table_user
(
 user_id INT IDENTITY () not NULL,
 user_name NVARCHAR (max) not NULL,
 last_updated_by    NVARCHAR (last_updated_date),    DATETIME,
CONSTRAINT user_pk PRIMARY KEY (user_id)
);


/*alter table adds multiple fields */
ALTER table Table_user ADD 
 department_id int not NULL
, company_id int. not null
 
  ,temp_col NVARCHAR (Ten)
;


/*alter table adds multiple foreign keys *
/ALTER table Table_user ADD 
CONSTRAINT user_department_fk FOREIGN key (department_id) REFERENCES table_department (department_id) 
, CONSTRAINT user_company_fk FOREIGN KEY (company_id) REFERENCES TABLE _company (company_id) 
 ;


/*alter Table Delete field */
ALTER table Table_user DROP COLUMN temp_col;