Any alcohol you buy at port stops or in the duty-free shop must be stored until disembarkation.
Alcohol purchased at the ships duty-free shop must be stored.
They have a corkage fee of $20.
Regent: Bring your own alcohol and consume booze bought at ports in your cabin.
Bonus, alcohol at the ships restaurants, bars, and in-room bars is complimentary!
The Worst
Carnival: You cant BYOB beyond one 750mL bottle of wine or champagne.
All alcohol you buy in-port or at the ships duty-free shop will be stored for the trip.
Luckily, all of this information is in the chart, linked below.
The Official Boozing Policies for the High Seas| Map Happy