# Change databaase column

**URL:** <https://www.ruby-forum.com/t/change-databaase-column/195303>\
**Category:** Rails\
**Created:** [September 21, 2010, 1:31pm UTC](https://www.ruby-forum.com/t/change-databaase-column/195303 "2010-09-21T13:31:33Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![hemantborole](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/h/b782af/32.png) [@hemantborole](https://www.ruby-forum.com/u/hemantborole)\
**Post date:** [September 21, 2010, 1:31pm UTC](https://www.ruby-forum.com/t/change-databaase-column/195303/1 "2010-09-21T13:31:33Z")

</div>

Guys,

I have create this database column a while ago-  
t.date :interview\_date, :null =\> false means that this column can not  
have null value and then i deployed it on my server. Now i want this  
column to be changed as  
t.date :interview\_date, :null =\> true so that my column can accept null  
values also.

Want to know each & every possible way… ?

Thanks in advance…

---

<div class="post-metadata">

**Author:** ![hemantborole](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/h/b782af/32.png) [@hemantborole](https://www.ruby-forum.com/u/hemantborole)\
**Post date:** [September 21, 2010, 2:49pm UTC](https://www.ruby-forum.com/t/change-databaase-column/195303/2 "2010-09-21T14:49:16Z")

</div>

On 21 September 2010 12:31, Hemant B. [removed\_email\_address@domain.invalid](mailto:removed_email_address@domain.invalid)  
wrote:

> Guys,
> 
> I have create this database column a while ago-  
> t.date :interview\_date, :null =\> false means that this column can not  
> have null value and then i deployed it on my server. Now i want this  
> column to be changed as  
> t.date :interview\_date, :null =\> true so that my column can accept null  
> values also.
> 
> Want to know each & every possible way… ?

I don’t know why you want to know all possible ways but the  
conventional way would be to use a migration and in there use  
change\_column.

Colin

---

<div class="post-metadata">

**Author:** ![hemantborole](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/h/b782af/32.png) [@hemantborole](https://www.ruby-forum.com/u/hemantborole)\
**Post date:** [September 22, 2010, 8:13am UTC](https://www.ruby-forum.com/t/change-databaase-column/195303/3 "2010-09-22T08:13:44Z")

</div>

Hey colin, Thanks for your reply. It worked.

Colin L. wrote:

> On 21 September 2010 12:31, Hemant B. [removed\_email\_address@domain.invalid](mailto:removed_email_address@domain.invalid)  
> wrote:
> 
> > Guys,
> > 
> > I have create this database column a while ago-  
> > t.date :interview\_date, :null =\> false means that this column can not  
> > have null value and then i deployed it on my server. Now i want this  
> > column to be changed as  
> > t.date :interview\_date, :null =\> true so that my column can accept null  
> > values also.
> > 
> > Want to know each & every possible way… ?
> 
> I don’t know why you want to know all possible ways but the  
> conventional way would be to use a migration and in there use  
> change\_column.
> 
> Colin