ALTER TABLE - adding a constraint.

[TimGoff]

Hello,

I would like to add a Primary Key based on Columns House_Number & Prodn_code - but the below doesn't appear to work....anybody any ideas?

Thanks
Tim

ALTER TABLE tbl_bcst_t_ver ADD PRIMARY KEY House_Prod TAG House_Prod

ALTER TABLE tbl_bcst_t_ver ALTER COLUMN House_Number, Prodn_code CHAR PRIMARY KEY

 

[PHV]

Something like this ?
ALTER TABLE tbl_bcst_t_ver ADD CONSTRAINT ConstraintName PRIMARY KEY (House_Number, Prodn_code)

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[TimGoff]

Works perfectly - thanks v much PHV.
Tim