Command Help : Alter table modify column

Database
Highlighted
Enthusiast

Re: Command Help : Alter table modify column

Depending on what exactly you are trying to do, you can run an update to change values in the table. To change column format I would do an insert select from the old table into a new table with the new format, assuming of course they are compatible

Enthusiast

Re: Command Help : Alter table modify column

Hi... 3 years later I see no answer...

 

Is there any update?

 

I'm new with teradata, and being using MSSQL, I would love to understand why this basic administrative tasks are supposed to take so long (create table, populate, delete old), etc, instead of a simply property change...