Skip to content

Database governance built for humans and agents — controlling changes and access across every major database.

4.9 KB
Raw Blame
- 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