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 UPPER_CASE_TABLE_NAME_WITHOUT_DOUBLE_QUOTES(ID INT);
changeType: 1
- statement: CREATE TABLE "UPPER_CASE_TABLE_NAME_WITH_DOUBLE_QUOTES"(ID INT);
changeType: 1
- statement: CREATE TABLE lower_case_table_name_without_double_quotes(ID INT);
changeType: 1
want:
- status: 2
code: 301
title: NAMING_TABLE
content: '"lower_case_table_name_without_double_quotes" mismatches table naming convention, naming format should be "^[A-Z]+(_[A-Z]+)*$"'
startposition:
line: 1
column: 0
endposition: null
- statement: CREATE TABLE "lower_case_table_name_with_double_quotes"(ID INT);
changeType: 1
want:
- status: 2
code: 301
title: NAMING_TABLE
content: '"lower_case_table_name_with_double_quotes" mismatches table naming convention, naming format should be "^[A-Z]+(_[A-Z]+)*$"'
startposition:
line: 1
column: 0
endposition: null
- statement: "CREATE TABLE \"\U0001F608EMOJI\U0001F604\"(ID INT);"
changeType: 1
want:
- status: 2
code: 301
title: NAMING_TABLE
content: "\"\U0001F608EMOJI\U0001F604\" mismatches table naming convention, naming format should be \"^[A-Z]+(_[A-Z]+)*$\""
startposition:
line: 1
column: 0
endposition: null
- statement: ALTER TABLE "lower_case_table_with_double_quotes" RENAME TO UPPER_CASE_TABLE_NAME_WITHOUT_DOUBLE_QUOTES;
changeType: 1
- statement: ALTER TABLE UPPER_CASE_TABLE_NAME RENAME TO "lower_case_table_with_double_quotes";
changeType: 1
want:
- status: 2
code: 301
title: NAMING_TABLE
content: '"lower_case_table_with_double_quotes" mismatches table naming convention, naming format should be "^[A-Z]+(_[A-Z]+)*$"'
startposition:
line: 1
column: 0
endposition: null
- statement: |-
CREATE TABLE UPPER_CASE_TABLE_NAME_WITHOUT_DOUBLE_QUOTES(ID INT);
ALTER TABLE UPPER_CASE_TABLE_NAME_WITHOUT_DOUBLE_QUOTES RENAME TO "lower_case_table_with_double_quotes";
changeType: 1
want:
- status: 2
code: 301
title: NAMING_TABLE
content: '"lower_case_table_with_double_quotes" mismatches table naming convention, naming format should be "^[A-Z]+(_[A-Z]+)*$"'
startposition:
line: 2
column: 0
endposition: null
- statement: |-
CREATE TABLE "lower_case_table_name_with_double_quotes"(ID INT);
ALTER TABLE "lower_case_table_name_with_double_quotes" RENAME TO UPPER_CASE_TABLE_NAME_WITHOUT_DOUBLE_QUOTES;
changeType: 1
want:
- status: 2
code: 301
title: NAMING_TABLE
content: '"lower_case_table_name_with_double_quotes" mismatches table naming convention, naming format should be "^[A-Z]+(_[A-Z]+)*$"'
startposition:
line: 1
column: 0
endposition: null
- statement: |-
CREATE TABLE "lowercase"(ID INT);
ALTER TABLE another_schema."lower_case" RENAME TO another_schema.UPPER_CASE_TABLE_NAME_WITHOUT_DOUBLE_QUOTES;
changeType: 1
want:
- status: 2
code: 301
title: NAMING_TABLE
content: '"lowercase" mismatches table naming convention, naming format should be "^[A-Z]+(_[A-Z]+)*$"'
startposition:
line: 1
column: 0
endposition: null