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 book (
id int,
name varchar(255)
);
COMMENT ON TABLE book IS 'comments';
changeType: 1
- statement: CREATE TABLE t(a int);
changeType: 1
want:
- status: 2
code: 1032
title: TABLE_COMMENT
content: Comment is required for table "TEST_DB"."T"
startposition:
line: 1
column: 0
endposition: null
- statement: |-
CREATE TABLE t(a int);
CREATE TABLE d(a int);
COMMENT ON TABLE t IS 'comments';
changeType: 1
want:
- status: 2
code: 1032
title: TABLE_COMMENT
content: Comment is required for table "TEST_DB"."D"
startposition:
line: 2
column: 0
endposition: null
- statement: |-
CREATE TABLE t(a int);
COMMENT ON TABLE t IS 'comments';
COMMENT ON TABLE t IS '';
changeType: 1
want:
- status: 2
code: 1032
title: TABLE_COMMENT
content: Comment is required for table "TEST_DB"."T"
startposition:
line: 1
column: 0
endposition: null
- statement: |-
CREATE TABLE t(a int);
COMMENT ON TABLE t IS 'looooooong comments';
changeType: 1
want:
- status: 2
code: 1301
title: TABLE_COMMENT
content: Table "TEST_DB"."T" comment is too long. The length of comment should be within 10 characters
startposition:
line: 1
column: 0
endposition: null