var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Change DDL and prevent Lock
I am dropping a primary index and recreating it in order to add an extra column into the pk.
However when I do this in test I get a NOWAIT error every time I try to use the table afterward.
The table is not effected by any other code running and has currently no data and is not being selected from.
Is there a command I can use to perform the DDL and prevent a lock on this table?
Your help as always is appreciated.