create_drop_table.sql

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

/*This SQL script uses Demos.abs database. 
  Please open ...\AbsoluteDatabase\Demos\Data\Demos.abs database file.
  This sample demonstrates use of CREATE TABLE and DROP TABLE statements.
  This SQL script contains three queries.
  First one deletes table named "developers".
  The second creates this table with 5 fields and 3 database options.
  The third query retrieves all rows from this table (of course, the table is empty at this point).*/

drop table developers;
create table developers (
  id AutoInc, 
  Code Integer, 
  Name varchar(20),
  Birthday Date,
  Photo Graphic 
  BlobCompressionMode 9 
  BlobBlockSize 1024 
  BlobCompressionAlgorithm ZLib
);
select * from developers;