/// <summary> /// Gets the tables for a database /// </summary> /// <param name="ConnectionString">Connection string</param> /// <param name="Temp">The database object</param> private static void GetTables(string ConnectionString, Database Temp) { string Command = "SELECT TABLE_CATALOG, TABLE_SCHEMA, TABLE_NAME, TABLE_TYPE FROM INFORMATION_SCHEMA.TABLES"; using (SQLHelper Helper = new SQLHelper(Command, ConnectionString, CommandType.Text)) { Helper.ExecuteReader(); while (Helper.Read()) { string TableName = Helper.GetParameter("TABLE_NAME", ""); string TableType = Helper.GetParameter("TABLE_TYPE", ""); if (TableType == "BASE TABLE") { Temp.AddTable(TableName); } else if (TableType == "VIEW") { Temp.AddView(TableName); } } } }