I want to change a column's data type from bit to int. There are data in the table already. I'm wondering if it is save/correct way to issue the following command to change the data type for that column.
ALTER TABLE database_table
ALTER COLUMN my_bit_columnINT;
Thanks.
It should work. The data will change to 0 (if it was False) or 1 (if it was True) after you change your column data type.
No comments:
Post a Comment