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: EXEC sp_rename N'Phone', N'Telephone', N'USERDATATYPE';
changeType: 1
want:
- status: 2
code: 102
title: SCHEMA_BACKWARD_COMPATIBILITY
content: sp_rename may cause incompatibility with the existing data and code, and break scripts and stored procedures.
startposition:
line: 1
column: 0
endposition: null
- statement: DROP TABLE MyTable;
changeType: 1
want:
- status: 2
code: 112
title: SCHEMA_BACKWARD_COMPATIBILITY
content: Drop table master.dbo.MyTable may cause incompatibility with the existing data and code
startposition:
line: 1
column: 0
endposition: null
- statement: |-
CREATE TABLE MyTable(Id INT PRIMARY KEY);
DROP TABLE MyTable;
changeType: 1
- statement: DROP SCHEMA MySchema;
changeType: 1
want:
- status: 2
code: 112
title: SCHEMA_BACKWARD_COMPATIBILITY
content: Drop schema master.myschema may cause incompatibility with the existing data and code
startposition:
line: 1
column: 0
endposition: null
- statement: |-
CREATE SCHEMA AUTHORIZATION dbo;
DROP SCHEMA dbo;
changeType: 1
- statement: DROP DATABASE MyDB;
changeType: 1
want:
- status: 2
code: 112
title: SCHEMA_BACKWARD_COMPATIBILITY
content: Drop database mydb may cause incompatibility with the existing data and code
startposition:
line: 1
column: 0
endposition: null
- statement: |-
CREATE DATABASE MyDB;
DROP DATABASE MyDB;
changeType: 1
- statement: |-
ALTER TABLE MyTable DROP COLUMN MyColumnOne, MyColumnTwo;
ALTER TABLE MyTable ALTER COLUMN MyColumnOne INT NOT NULL;
ALTER TABLE MyTable ADD PRIMARY KEY (MyColumnOne, MyColumnTwo);
ALTER TABLE MyTable ADD UNIQUE (MyColumnOne, MyColumnTwo);
ALTER TABLE MyTable ADD CHECK NOT FOR REPLICATION (MyColumnOne > 0);
ALTER TABLE MyTable WITH NOCHECK ADD CONSTRAINT MyConstraint CHECK (MyColumnOne > 0);
ALTER TABLE MyTable WITH CHECK ADD CONSTRAINT MyConstraint CHECK (MyColumnOne > 0);
ALTER TABLE MyTable WITH NOCHECK ADD FOREIGN KEY (MyColumnOne) REFERENCES MyTableTwo(MyColumnTwo);
ALTER TABLE MyTable WITH CHECK ADD FOREIGN KEY (MyColumnOne) REFERENCES MyTableTwo(MyColumnTwo);
changeType: 1
want:
- status: 2
code: 112
title: SCHEMA_BACKWARD_COMPATIBILITY
content: Drop column mycolumnone may cause incompatibility with the existing data and code
startposition:
line: 1
column: 0
endposition: null
- status: 2
code: 112
title: SCHEMA_BACKWARD_COMPATIBILITY
content: Drop column mycolumntwo may cause incompatibility with the existing data and code
startposition:
line: 1
column: 0
endposition: null
- status: 2
code: 111
title: SCHEMA_BACKWARD_COMPATIBILITY
content: Alter COLUMN mycolumnone may cause incompatibility with the existing data and code
startposition:
line: 2
column: 0
endposition: null
- status: 2
code: 106
title: SCHEMA_BACKWARD_COMPATIBILITY
content: Add PRIMARY KEY may cause incompatibility with the existing data and code
startposition:
line: 3
column: 0
endposition: null
- status: 2
code: 107
title: SCHEMA_BACKWARD_COMPATIBILITY
content: Add UNIQUE KEY may cause incompatibility with the existing data and code
startposition:
line: 4
column: 0
endposition: null
- status: 2
code: 109
title: SCHEMA_BACKWARD_COMPATIBILITY
content: Add CHECK may cause incompatibility with the existing data and code
startposition:
line: 5
column: 0
endposition: null
- status: 2
code: 108
title: SCHEMA_BACKWARD_COMPATIBILITY
content: Add CHECK WITH NO CHECK may cause incompatibility with the existing data and code
startposition:
line: 6
column: 0
endposition: null
- status: 2
code: 108
title: SCHEMA_BACKWARD_COMPATIBILITY
content: Add FOREIGN KEY WITH NO CHECK may cause incompatibility with the existing data and code
startposition:
line: 8
column: 0
endposition: null
- statement: EXEC sp_rename 'Sales.SalesTerritory', 'SalesTerr';
changeType: 1
want:
- status: 2
code: 102
title: SCHEMA_BACKWARD_COMPATIBILITY
content: sp_rename may cause incompatibility with the existing data and code, and break scripts and stored procedures.
startposition:
line: 1
column: 0
endposition: null
- statement: EXEC sp_rename 'dbo.ErrorLog.ErrorTime', 'ErrorDateTime', 'COLUMN';
changeType: 1
want:
- status: 2
code: 102
title: SCHEMA_BACKWARD_COMPATIBILITY
content: sp_rename may cause incompatibility with the existing data and code, and break scripts and stored procedures.
startposition:
line: 1
column: 0
endposition: null