The Teradata Database channel includes discussions around advanced Teradata features such as high-performance parallel database technology, the optimizer, mixed workload management solutions, and other related technologies.
What is the easiest approach to change the data type of a particular column in all tables in a database? Say, for instance, I do have a data type of COLA defined as INTEGER, FLOAT, DECIMAL in my database and the same COLA is being used extensively in many tables ( 1000 + tables across DBs). Now the source is changing the datatype for VARCHAR to handle alphanumeric characters.
I know in Teradata we can use ALTER TABLE statement to modify the precision, but not a datatype. Is there any way than rebuilding the table with the new datatype. Rebuilding will be a very tedious approach for these many tables. ( rename the existing table, deploy new DDL, & insert back all records and remove the temp table ) .