This sample illustrates use of ALTER TABLE statement with MODIFY option.
This SQL script contains eight queries.
First one deletes table named "MyTable".
The second creates this table with 2 fields.
Queries 3 - 6 insert some data into the table.
The seventh query modifies column named "val1" so that it turns to be string.
Query #8 retrieves all rows from this table.
drop table MyTable;
create table MyTable (ID AutoInc, val1 Integer, val2 string(10));
insert into MyTable (val1, val2) values (2,'2');
insert into MyTable (val1, val2) values (4,'3');
insert into MyTable (val1, val2) values (5,'9');
insert into MyTable (val1, val2) values (7,'Hello');
alter table MyTable mofify (val1 string(5));
select * from MyTable order by ID val2 desc;
Download Absolute Database | Learn more |
