Can v edit the column's data type after creating the table?

Answer 1

Yes, you can use the ALTER command to change the data type. SQL will try to automatically convert the data in the table to the target data type, which might cause data truncation.