mirror of
https://github.com/grafana/grafana.git
synced 2025-07-31 01:42:13 +08:00
8ce8c1635f
Valid MSSQL database names can contain characters like `-`, which need to be escaped when used in queries. This PR wraps database names in `[]`, and fixes Grafana issue #58757.
17 lines
568 B
TypeScript
17 lines
568 B
TypeScript
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}';`;
|
|
}
|