Alter table statement collection

Add new fields to the table:
Alter table pro_producedailyitems add tiernum decimal (8, 2)
Add default values to existing fields:
Alter table pro_producedailyitems add constraint df_pro_producedailyitems_tiernum default 1 for tiernum
Add a foreign key:
Alter table ssd_iinwhrecord add constraint fk_ssd_iinwhrecord_pro_producedailyt foreign key (cbedcode) References pro_producedailyt (cbedcode)
Modify the field length:
Alter table pro_producedailyitemst alter column factmatenum decimal (18, 2)