alter_table_modify.sql

来自「AbsDataBase5.16 最新版」· SQL 代码 · 共 18 行

/*This SQL script uses Demos.abs database. 
  Please open ...\AbsoluteDatabase\Demos\Data\Demos.abs database file.
  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;