Joined: 26 May 2005 Posts: 178 Location: Copenhagen, Denmark
While you are talking about DB2, DELETE always refers to data and DROP refers to a DB2 Object.
Once a table is created you cannot RENAME it.
You cannot drop a column and add a column in between.
You can add a column at the end of the table. Alter table ADD COLUMN would obviously add the column at the end. Thanks..!