Today, I am starting a new topic in my blog – Teradata tips and Tricks for Oracle developers.
It is not very hard for a seasoned Oracle professional to learn Teradata SQL. At the same time, there are syntax nuances that need to be remembered. This is the first post that should help Oracle developers to be productive with Teradata SQL.
ALTER TABLE [table name] ADD ( column1 datatype1 ..., column2 datatype2 ..., ... columnN datatypeN ... )
ALTER TABLE [table name] ADD column1 datatype1 ..., ADD column2 datatype2 ..., ... ADD columnN datatypeN ...
Notice, that Teradata SQL syntax does not use parenthesis and requires “ADD” for every column being added.