internal override string[] LoadTables(DbGateway gateway)
{
return(gateway.LoadArray <string>(
// @"SELECT TABLE_SCHEMA, TABLE_NAME, OBJECTPROPERTY(object_id(TABLE_NAME), N'IsUserTable') AS type
@"SELECT TABLE_NAME FROM INFORMATION_SCHEMA.TABLES WHERE OBJECTPROPERTY(object_id(TABLE_NAME), N'IsUserTable')=1",
"TABLE_NAME"));
}
internal override string[] LoadTables(DbGateway gateway)
{
return(gateway.LoadArray <string>("select relname from pg_class", "relname"));
}
internal override string[] LoadTables(DbGateway gateway)
{
return(gateway.LoadArray <string>("SHOW TABLE STATUS", "Name"));
}
internal override string[] LoadTables(DbGateway gateway)
{
return(gateway.LoadArray <string>(
@"SELECT name FROM sqlite_master WHERE type='table' ORDER BY name", "name"));
}