Change databaase column

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…

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

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

This forum is not affiliated to the Ruby language, Ruby on Rails framework, nor any Ruby applications discussed here.

| Privacy Policy | Terms of Service | Remote Ruby Jobs