public MetaTableCollection GetTables(bool includeSystemTables) { if(con.State != ConnectionState.Open) con.Open(); MetaTableCollection tables = new MetaTableCollection (); string sql = "SELECT name " + "FROM sqlite_master " + "WHERE type = 'table' " + "ORDER BY name"; IDbCommand cmd = con.CreateCommand(); cmd.CommandText = sql; IDataReader reader = cmd.ExecuteReader(); while(reader.Read()) { MetaTable table = new MetaTable(reader.GetString(0)); tables.Add(table); } reader.Close(); reader = null; return tables; }
public MetaTableCollection GetTables(bool includeSystemTables) { if (con.State != ConnectionState.Open) { con.Open(); } MetaTableCollection tables = new MetaTableCollection(); string sql = "select schemaname, tablename " + "from pg_tables"; sql = sql + " ORDER BY 1,2"; IDbCommand cmd = con.CreateCommand(); cmd.CommandText = sql; IDataReader reader = cmd.ExecuteReader(); while (reader.Read()) { MetaTable table = new MetaTable(reader.GetString(0), reader.GetString(1)); tables.Add(table); } reader.Close(); reader = null; return(tables); }
public MetaTableCollection GetTables(bool includeSystemTables) { if(con.State != ConnectionState.Open) con.Open(); MetaTableCollection tables = new MetaTableCollection (); string sql = "select schemaname, tablename " + "from pg_tables"; sql = sql + " ORDER BY 1,2"; IDbCommand cmd = con.CreateCommand(); cmd.CommandText = sql; IDataReader reader = cmd.ExecuteReader(); while(reader.Read()) { MetaTable table = new MetaTable(reader.GetString(0), reader.GetString(1)); tables.Add(table); } reader.Close(); reader = null; return tables; }
public MetaTableCollection GetTables(bool includeSystemTables) { if(con.State != ConnectionState.Open) con.Open(); MetaTableCollection tables = new MetaTableCollection (); string where; if(includeSystemTables == true) where = ""; else where = "WHERE OWNER NOT IN ('SYS','SYSTEM','MDSYS','CTXSYS','WMSYS','WKSYS')"; string sql = "SELECT OWNER, TABLE_NAME, TABLESPACE_NAME " + "FROM ALL_TABLES " + where + " ORDER BY 1, 2"; IDbCommand cmd = con.CreateCommand(); cmd.CommandText = sql; IDataReader reader = cmd.ExecuteReader(); while(reader.Read()) { MetaTable table = new MetaTable(reader.GetString(0), reader.GetString(1)); tables.Add(table); } reader.Close(); reader = null; return tables; }
public MetaTableCollection GetTables(bool includeSystemTables) { if (con.State != ConnectionState.Open) { con.Open(); } MetaTableCollection tables = new MetaTableCollection(); string sql = "SELECT name " + "FROM sqlite_master " + "WHERE type = 'table' " + "ORDER BY name"; IDbCommand cmd = con.CreateCommand(); cmd.CommandText = sql; IDataReader reader = cmd.ExecuteReader(); while (reader.Read()) { MetaTable table = new MetaTable(reader.GetString(0)); tables.Add(table); } reader.Close(); reader = null; return(tables); }
public MetaTableCollection GetTables(bool includeSystemTables) { if (con.State != ConnectionState.Open) { con.Open(); } MetaTableCollection tables = new MetaTableCollection(); string sql = ""; if (infoSchemaExists) { sql = "select table_schema, table_name, " + " table_type from INFORMATION_SCHEMA.TABLES"; } else { sql = "SHOW TABLES"; } IDbCommand cmd = con.CreateCommand(); cmd.CommandText = sql; IDataReader reader = null; try { reader = cmd.ExecuteReader(); } catch (Exception e) { infoSchemaExists = false; sql = "SHOW TABLES"; reader = cmd.ExecuteReader(); } while (reader.Read()) { MetaTable table = null; if (infoSchemaExists) { table = new MetaTable(reader.GetString(0), reader.GetString(1)); } else { table = new MetaTable(reader.GetString(0)); } tables.Add(table); } reader.Close( ); reader = null; return(tables); }
public MetaTableCollection GetTables(bool includeSystemTables) { if(con.State != ConnectionState.Open) con.Open(); MetaTableCollection tables = new MetaTableCollection (); DataTable table = GetSchema ("Tables", new string[] {null, null, null, "TABLE"}); for (int r = 0; r < table.Rows.Count; r++) { DataRow row = table.Rows[r]; string tableName = row["TABLE_NAME"].ToString(); MetaTable mtable = new MetaTable(tableName); tables.Add(mtable); } return tables; }
public MetaTableCollection GetTables(bool includeSystemTables) { if (con.State != ConnectionState.Open) { con.Open(); } MetaTableCollection tables = new MetaTableCollection(); string where; if (includeSystemTables == true) { where = "'U','S'"; } else { where = "'U'"; } string sql = "SELECT su.name AS owner, so.name as table_name, so.id as table_id, " + " so.crdate as created_date, so.xtype as table_type " + "FROM dbo.sysobjects so, dbo.sysusers su " + "WHERE xtype IN (" + where + ") " + "AND su.uid = so.uid " + "ORDER BY 1, 2"; IDbCommand cmd = con.CreateCommand(); cmd.CommandText = sql; IDataReader reader = cmd.ExecuteReader(); while (reader.Read()) { MetaTable table = new MetaTable(reader.GetString(0), reader.GetString(1)); tables.Add(table); } reader.Close(); reader = null; return(tables); }
public MetaTableCollection GetTables(bool includeSystemTables) { if(con.State != ConnectionState.Open) con.Open(); MetaTableCollection tables = new MetaTableCollection (); string sql = ""; if (infoSchemaExists) sql = "select table_schema, table_name, " + " table_type from INFORMATION_SCHEMA.TABLES"; else sql = "SHOW TABLES"; IDbCommand cmd = con.CreateCommand(); cmd.CommandText = sql; IDataReader reader = null; try { reader = cmd.ExecuteReader(); } catch(Exception e) { infoSchemaExists = false; sql = "SHOW TABLES"; reader = cmd.ExecuteReader(); } while (reader.Read ()) { MetaTable table = null; if (infoSchemaExists) table = new MetaTable (reader.GetString (0), reader.GetString (1)); else table = new MetaTable (reader.GetString (0)); tables.Add(table); } reader.Close( ); reader = null; return tables; }
public MetaTableCollection GetTables(bool includeSystemTables) { if (con.State != ConnectionState.Open) { con.Open(); } MetaTableCollection tables = new MetaTableCollection(); DataTable table = GetSchema("Tables", new string[] { null, null, null, "TABLE" }); for (int r = 0; r < table.Rows.Count; r++) { DataRow row = table.Rows[r]; string tableName = row["TABLE_NAME"].ToString(); MetaTable mtable = new MetaTable(tableName); tables.Add(mtable); } return(tables); }
public MetaTableCollection GetTables(bool includeSystemTables) { if (con.State != ConnectionState.Open) { con.Open(); } MetaTableCollection tables = new MetaTableCollection(); string where; if (includeSystemTables == true) { where = ""; } else { where = "WHERE OWNER NOT IN ('SYS','SYSTEM','MDSYS','CTXSYS','WMSYS','WKSYS')"; } string sql = "SELECT OWNER, TABLE_NAME, TABLESPACE_NAME " + "FROM ALL_TABLES " + where + " ORDER BY 1, 2"; IDbCommand cmd = con.CreateCommand(); cmd.CommandText = sql; IDataReader reader = cmd.ExecuteReader(); while (reader.Read()) { MetaTable table = new MetaTable(reader.GetString(0), reader.GetString(1)); tables.Add(table); } reader.Close(); reader = null; return(tables); }
public MetaTableCollection GetTables(bool includeSystemTables) { if(con.State != ConnectionState.Open) con.Open(); MetaTableCollection tables = new MetaTableCollection (); string where; if(includeSystemTables == true) where = "'U','S'"; else where = "'U'"; string sql = "SELECT su.name AS owner, so.name as table_name, so.id as table_id, " + " so.crdate as created_date, so.xtype as table_type " + "FROM dbo.sysobjects so, dbo.sysusers su " + "WHERE xtype IN (" + where + ") " + "AND su.uid = so.uid " + "ORDER BY 1, 2"; IDbCommand cmd = con.CreateCommand(); cmd.CommandText = sql; IDataReader reader = cmd.ExecuteReader(); while(reader.Read()) { MetaTable table = new MetaTable(reader.GetString(0), reader.GetString(1)); tables.Add(table); } reader.Close(); reader = null; return tables; }