Synametrics Technologies

The Netezza does not have an alter table syntax that can add or drop columns. You have to generate a CREATE TABLE AS SELECT FROM ...; to a temp table, drop the old table, and then ALTER TABLE RENAME TO . This is REALLY painful on large tables where you insert or drop a column that is not at the end because you have to list each column explicitly in the CTAS. It would be nice to be able to generate all this SQL automatically (I believe the old SQL Server 2000 Query Manager does something like this automatically)

Navigation

• Home
• Products
• About us
• Blog
• Forums

Social Media