Creating Composite key

[prileep]

I have a table "Transactio n" with the following struct

Transaction
TransactionID int primary key,
CustomerID int,
TranTime DateTime
----------------------------------------------------------------
How can i set a composite key between CustomerID and TranTime

[ronverdonk]

You mean in the table definition itself? Like this

ALTER TABLE table ADD COLUMN comp_key varchar(20) AFTER CustomerID;

Ronald :cool: