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
    WHERE TABLE_TYPE = 'BASE TABLE'`;
}

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}';`;
}
