/// <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();
