Skip to content

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

1.1 KB
Raw Blame
- description: Case insensitive query but resource column should take original case.
  statement: SELECT dbo.mytable1.a FROM dbo.[mytable1] ;
  defaultDatabase: db
  ignoreCaseSensitive: true
  metadata:
    - |-
      {
        "name":  "db",
        "schemas":  [
          {
            "name": "dbo",
            "tables":  [
              {
                "name":  "MyTable1",
                "columns":  [
                  {
                    "name":  "a"
                  },
                  {
                    "name":  "b"
                  }
                ]
              }
            ]
          }
        ]
      }
  querySpan:
    type: 1
    results:
        - name: a
          sourcecolumns:
            - server: ""
              database: db
              schema: dbo
              table: MyTable1
              column: a
          isplainfield: true
          sourcefieldpaths: []
          selectasterisk: false
    sourcecolumns:
        - server: ""
          database: db
          schema: dbo
          table: mytable1
          column: ""
    predicatecolumns: []