1#@!#!123s

: / usr / share / grafana / public / app / plugins / datasource / mssql /

Filename : MSSqlMetaQuery.ts

back

export function showDatabases() {
  // Return only user defined databases
  return `SELECT name FROM sys.databases WHERE name NOT IN ('master', 'tempdb', 'model', 'msdb');`;
}

export function getSchemaAndName(database?: string) {
  return `SELECT TABLE_SCHEMA + '.' + TABLE_NAME as schemaAndName
    FROM [${database}].INFORMATION_SCHEMA.TABLES`;
}

export function getSchema(database?: string, table?: string) {
  return `
   USE ${database}
   SELECT COLUMN_NAME as 'column',DATA_TYPE as 'type'
   FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME='${table}';`;
}