Database governance built for humans and agents — controlling changes and access across every major database.
Go cicddata-governancedata-maskingdata-securitydatabase-accessdatabase-governancedevopsdevsecopsflywaygitopsliquibasemongodbmysqloraclepostgresqlschema-migrationssecuritysql-clientsqlservertidb
- statement: CREATE TABLE "table"(id int, name varchar(255))
changeType: 1
want:
- status: 2
code: 309
title: NAMING_IDENTIFIER_CASE
content: Identifier "table" should be upper case
startposition:
line: 1
column: 0
endposition: null
- statement: CREATE TABLE tt(id int, name varchar(255))
changeType: 1
- statement: CREATE TABLE "Tt"(id int, name varchar(255))
changeType: 1
want:
- status: 2
code: 309
title: NAMING_IDENTIFIER_CASE
content: Identifier "Tt" should be upper case
startposition:
line: 1
column: 0
endposition: null
- statement: ALTER TABLE tech_book RENAME TO analyze
changeType: 1
- statement: |-
create table techBook(id int);
ALTER TABLE techBook RENAME TO tech_book_tmp;
changeType: 1
- statement: |-
DECLARE
"v_Count" NUMBER;
BEGIN
SELECT COUNT(1) INTO "v_Count" FROM "Tt";
END;
changeType: 1
want:
- status: 2
code: 309
title: NAMING_IDENTIFIER_CASE
content: Identifier "v_Count" should be upper case
startposition:
line: 2
column: 0
endposition: null
- statement: CREATE CLUSTER "MixedCase" (id NUMBER)
changeType: 1
want:
- status: 2
code: 309
title: NAMING_IDENTIFIER_CASE
content: Identifier "MixedCase" should be upper case
startposition:
line: 1
column: 0
endposition: null