Hi folks,

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.