# Preconditions column exists

**URL:** <https://forum.liquibase.org/t/preconditions-column-exists/3259>\
**Category:** General Discussion\
**Created:** [August 4, 2015, 9:34pm UTC](https://forum.liquibase.org/t/preconditions-column-exists/3259 "2015-08-04T21:34:00Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![un1438701977998r82id](https://avatars.discourse-cdn.com/v4/letter/u/c67d28/32.png) [@un1438701977998r82id](https://forum.liquibase.org/u/un1438701977998r82id)\
**Post date:** [August 4, 2015, 9:34pm UTC](https://forum.liquibase.org/t/preconditions-column-exists/3259/1 "2015-08-04T21:34:00Z")

</div>

Oracle doesn’t consider case when checking for table names or column names.

Thus you don’t even have to rename your columns !

---

<div class="post-metadata">

**Author:** ![Sake](https://avatars.discourse-cdn.com/v4/letter/s/c5a1d2/32.png) [@Sake](https://forum.liquibase.org/u/Sake)\
**Post date:** [August 4, 2015, 9:34pm UTC](https://forum.liquibase.org/t/preconditions-column-exists/3259/2 "2015-08-04T21:34:00Z")

</div>

Using liquibase 3.4.1 I want to rename my columns in Oracle to uppercase if they exist. I always get the following error no matter what I do:

 

```
Unexpected error running Liquibase: ORA-00957: duplicate column name [Failed SQL: ALTER TABLE "SYSTEM"."MYTABLE" RENAME COLUMN "id" TO "ID"]
```

 

My precondition looks like this:

 

```

```

 

I tried following: - removing objectQuotingStrategy - adding SQL check:

 

```
<sqlCheck expectedResult=“1”> SELECT COUNT(*) FROM USER_TAB_COLUMNS WHERE TABLE_NAME=‘MYTABLE’ AND COLUMN_NAME=‘id’ </sqlCheck>
```

 

Any idea why this happens? 😕