public bool CheckTableExist(OleDbConnection conn, string tblName) { bool b = false; string[] restrictions = new string[] { null, null, tblName }; DataTable dTable = conn.GetSchema("Tables", restrictions); if (dTable.Rows.Count == 0) { b = false; } else { b = true; } return b; }
SELECT COUNT(table_name) FROM user_tables WHERE table_name='tlbNameToCheckFor'
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)