Change databaase column

Rails
1

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…

2

On 21 September 2010 12:31, Hemant B. [email protected]
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

3

Hey colin, Thanks for your reply. It worked.

Colin L. wrote:

On 21 September 2010 12:31, Hemant B. [email protected]
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