is there any other way to alter the column data type of table
procedure we follow
create a temp table with old table ddl
insert the data into temp from old
create the new table with modifications of old table
insert back data into new table
drop temp table
i dont know why teradata doesnot have alter to data type without dropping the table.
Solved! Go to Solution.
There are a lot of restrictions for altering a data type, it's only allowed in cases where the internal storage will not be changed.
Besides Carlos way you can simplify your current approach:
I try to avoid creating a new table if possible, thus preserving the objectID, rights, statistics, etc... And saving space too ;-)