Thursday, February 9, 2012

Adding column to Existing Table

Syntax
alter table <tableName> add  <New_Column> <datatype_with_size>;



SQL>alter table employee add  empsal number(5);

No comments:

Post a Comment