Database governance built for humans and agents — controlling changes and access across every major database.
Go cicddata-governancedata-maskingdata-securitydatabase-accessdatabase-governancedevopsdevsecopsflywaygitopsliquibasemongodbmysqloraclepostgresqlschema-migrationssecuritysql-clientsqlservertidb
- 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: []