/// <inheritdoc /> protected override string[] GetTableNames() { var result = new List <string>(); var rows = SqlStorage.Query("EXEC stables @table_owner='dbo',@table_qualifier='" + Name + "';"); foreach (var row in rows) { var tableName = (string)row[2]; result.Add(tableName); } return(result.ToArray()); }
/// <inheritdoc /> protected override string[] GetTableNames() { var result = new List <string>(); var rows = SqlStorage.Query(database: Name, table: "sqlite_master", cmd: "SELECT name, type FROM sqlite_master WHERE type='table' AND name NOT LIKE 'sqlite_%'"); foreach (var row in rows) { result.Add((string)row[0]); } return(result.ToArray()); }
/// <inheritdoc /> protected override string[] GetTableNames() { var result = new List <string>(); var rows = SqlStorage.Query(database: "information_schema", table: "TABLES", cmd: "SELECT table_name,table_schema,table_type FROM information_schema.TABLES where table_type='BASE TABLE' AND table_schema LIKE " + SqlStorage.EscapeString(Name)); foreach (var row in rows) { result.Add((string)row[0]); } return(result.ToArray()); }
/// <inheritdoc /> protected override string[] GetTableNames() => SqlStorage.Query(database: Name, table: "pg_tables", cmd: "SELECT tablename FROM pg_tables").Select(r => r[0].ToString()).ToArray();