Skip to Main Content

SQLcl: MCP Server & SQL Prompt

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

SQLCL - Generate Drop scripts - disable comments

Lukasz Wasylow4 days ago

Hi

Just wanted to check if there is an option to disable commenting the auto generated drop scripts ?

I get it why its being commented out for safety but, doing a lot of changes and running stage couple times before actually release causing the drop scripts to be regenerated each time.

e.g.

/* Uncomment drop statement after ensuring it is performing the correct actions 
DROP TABLE "TEST"."TEST" CASCADE CONSTRAINTS; 
*/ 

after changing that file to

DROP TABLE "TEST"."TEST" CASCADE CONSTRAINTS; 

Once run stage again it reverts to above.

Would be nice to disable that option or maybe add it as a runtime project stage -enable_drop etc. , or maybe there is I just cant figure it out ?

Cheers

Lukasz

Comments
Post Details
Added 4 days ago
0 comments
31 views