Script to drop all indexes on a table
Given a table name as the parameter, all the indexes on the table can be dropped. This script can be useful if you want to drop indexes on a table inside another procedure
2002-03-12
11,109 reads
Blogs
Daily Coping 7 Feb 2023
By Steve Jones
Today’s coping tip is to go to bed in good time and allow yourself...
Tales From The Field Weekly Wrap Up for the Week of 01-31-2023
By SQLBalls
Hello Dear Reader! After a weekend with a lot of activities, it was a...
Creating a Flyway Desktop Shadow Database in PostgreSQL
By Steve Jones
In order to generate migrations, we need to configure Flyway to use a shadow...
Forums
Converting nested Json document to SQL data
I have response from a API that look like { "responseCode": 200, "message": "success",...
Converting nested Json document to SQL data
I have response from a API that look like { "responseCode": 200, "message": "success",...
To Drop or Not to Drop (the temp table question)
So here's a thing that I've been told several times over the past few...
Ask SSC