• Home
• org.liquibase
• liquibase-test-harness
• 1.0.5
• source code
• dropCamelCasePrimaryKey.sql

×

Project download

Many resources are needed to download a project. Please understand that we have to compensate our server costs. Thank you in advance.
Project price only 1 $

You can buy this project and download/modify it how often you want.

liquibase.harness.change.expectedSql.postgresql.9.dropCamelCasePrimaryKey.sql Maven / Gradle / Ivy

CREATE TABLE public."camelCase" (id SERIAL NOT NULL, CONSTRAINT "camelCase_pkey" PRIMARY KEY (id))
DO $$ DECLARE constraint_name varchar
BEGIN
SELECT tc.CONSTRAINT_NAME into strict constraint_name
FROM INFORMATION_SCHEMA.TABLE_CONSTRAINTS tc
WHERE CONSTRAINT_TYPE = 'PRIMARY KEY'
AND TABLE_NAME = 'camelCase' AND TABLE_SCHEMA = 'public'
EXECUTE 'alter table public."camelCase" drop constraint "' || constraint_name || '"'
END $$