# \#case-sensitivity

**URL:** https://discourse.getdbt.com/tag/case-sensitivity/49.md

[Latest](https://discourse.getdbt.com/latest.md) · [Categories](https://discourse.getdbt.com/categories.md) · [Tags](https://discourse.getdbt.com/tags.md)

---

## [Testing case sensitive column names](https://discourse.getdbt.com/t/testing-case-sensitive-column-names/1077)

<div class="topic-metadata">

**Author:** [@marc.clijsters](https://discourse.getdbt.com/u/marc.clijsters)\
**Replies:** 3\
**Last updated:** [June 2, 2020, 1:39am UTC](https://discourse.getdbt.com/t/testing-case-sensitive-column-names/1077 "2020-06-02T01:39:42Z")

</div>

Our users love case sensitive column names like CustomerID. When I try to put a test (unique or not null) on this column, the db does not recognize the column. I used “CustomerID” and ‘CustomerID’ but when the statemen…