Skip to content

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

3.8 KB
Raw Blame
- description: Join Alias and Asterisk
  statement: SELECT t.* FROM MyTable1 t JOIN MyTable2 u ON t.a = u.c;
  defaultDatabase: db
  ignoreCaseSensitive: true
  metadata:
    - |-
      {
        "name":  "db",
        "schemas":  [
          {
            "name": "dbo",
            "tables":  [
              {
                "name":  "MyTable1",
                "columns":  [
                  {
                    "name":  "a"
                  },
                  {
                    "name":  "b"
                  }
                ]
              },
              {
                "name":  "MyTable2",
                "columns":  [
                  {
                    "name":  "c"
                  },
                  {
                    "name":  "d"
                  }
                ]
              }
            ]
          }
        ]
      }
  querySpan:
    type: 1
    results:
        - name: a
          sourcecolumns:
            - server: ""
              database: db
              schema: dbo
              table: MyTable1
              column: a
          isplainfield: true
          sourcefieldpaths: []
          selectasterisk: false
        - name: b
          sourcecolumns:
            - server: ""
              database: db
              schema: dbo
              table: MyTable1
              column: b
          isplainfield: true
          sourcefieldpaths: []
          selectasterisk: false
    sourcecolumns:
        - server: ""
          database: db
          schema: dbo
          table: MyTable1
          column: ""
        - server: ""
          database: db
          schema: dbo
          table: MyTable2
          column: ""
    predicatecolumns:
        - server: ""
          database: db
          schema: dbo
          table: MyTable1
          column: a
        - server: ""
          database: db
          schema: dbo
          table: MyTable2
          column: c
- description: Join Alias
  statement: SELECT t.a, t.b FROM MyTable1 t JOIN MyTable2 u ON t.a = u.c;
  defaultDatabase: db
  ignoreCaseSensitive: true
  metadata:
    - |-
      {
        "name":  "db",
        "schemas":  [
          {
            "name": "dbo",
            "tables":  [
              {
                "name":  "MyTable1",
                "columns":  [
                  {
                    "name":  "a"
                  },
                  {
                    "name":  "b"
                  }
                ]
              },
              {
                "name":  "MyTable2",
                "columns":  [
                  {
                    "name":  "c"
                  },
                  {
                    "name":  "d"
                  }
                ]
              }
            ]
          }
        ]
      }
  querySpan:
    type: 1
    results:
        - name: a
          sourcecolumns:
            - server: ""
              database: db
              schema: dbo
              table: MyTable1
              column: a
          isplainfield: true
          sourcefieldpaths: []
          selectasterisk: false
        - name: b
          sourcecolumns:
            - server: ""
              database: db
              schema: dbo
              table: MyTable1
              column: b
          isplainfield: true
          sourcefieldpaths: []
          selectasterisk: false
    sourcecolumns:
        - server: ""
          database: db
          schema: dbo
          table: MyTable1
          column: ""
        - server: ""
          database: db
          schema: dbo
          table: MyTable2
          column: ""
    predicatecolumns:
        - server: ""
          database: db
          schema: dbo
          table: MyTable1
          column: a
        - server: ""
          database: db
          schema: dbo
          table: MyTable2
          column: c