public bool TableExists(string testTableName)
{
string testQuery = "select * from [INFORMATION_SCHEMA].[COLUMNS] where table_name = @TableName ";
List<SqlParameter> parms = new List<SqlParameter>();
SqlParameter parmKey = new SqlParameter();
parmKey.ParameterName = "@TableName";
parmKey.SqlDbType = SqlDbType.VarChar;
parmKey.Size = 2000;
parmKey.Direction = ParameterDirection.Input;
parmKey.Value = testTableName;
parms.Add(parmKey);
DataTable table1 = GetTestData(testQuery, parms);
if (table1.Rows.Count < 1) {
return false;
}
return true;
}