|
View previous topic :: View next topic
|
| Author |
Message |
jayanta_nit
New User
Joined: 13 Apr 2006
Posts: 22
Location: hyderabad
|
|
|
|
| Can I delete a column from a table in DB2???? |
|
| Back to top |
|
 |
ofer71
Global Moderator
Joined: 27 Dec 2005
Posts: 2358
Location: Israel
|
|
|
|
No.
O. |
|
| Back to top |
|
|
vini_srcna
Active User
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..! |
|
| Back to top |
|
|
jayanta_nit
New User
Joined: 13 Apr 2006
Posts: 22
Location: hyderabad
|
|
|
|
| thanks vini_srcna |
|
| Back to top |
|
|
H Muraleedhar
New User
Joined: 03 Mar 2009
Posts: 12
Location: Chennai
|
|
|
|
| Is there any way to change the constraints ( data type ) of a column in DB2 ( version 8.1) ? |
|
| Back to top |
|
|
|
|
