View previous topic :: View next topic
|
Author |
Message |
krishna_mf
New User
Joined: 31 Jan 2007 Posts: 56 Location: banglore
|
|
|
|
hi
when i am exceuting the below query its is giving error like illegeal symbol integer with sqlcode -104
alter table emptab add column empsal integer ;
can anyone please tell me what is correct syntax to add a column in a DB2 table |
|
Back to top |
|
|
kussu Warnings : 1 New User
Joined: 16 May 2007 Posts: 33 Location: India
|
|
|
|
The Syntax for this should be as like mentioned below
ALTER TABLE table_name
ADD column_name column-definition;
For example:
ALTER TABLE supplier
ADD supplier_name varchar2(50); |
|
Back to top |
|
|
|