Carrotware.CMS.DBUpdater.DatabaseUpdate.TableExists C# (CSharp) Method

TableExists() public method

public TableExists ( string testTableName ) : bool
testTableName string
return bool
        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;
        }