Firebird

Firebird†

InterBase 6.0オープンソースがベースとなっている。
MS-Access同様 1DB = 1ファイル形式を採用している。
http://firebird.gr.jp/

Version 2.1
http://sourceforge.net/projects/firebird/

システムテーブル(RDB$)。

コンソール・コマンド†

isql

isql [-u UserName] [-p PassWord] [-i InputFile] [-o OutputFile] [DB File]

<<isql オプション>>
isql [<database>] [-e] [-t <terminator>] [-i <inputfile>] [-o <outputfile>]
     [-x|-a] [-d <target db>] [-u <user>] [-p <password>]
     [-page <pagelength>] [-n] [-m] [-q] [-s <sql_dialect>]
     [-r <rolename>] [-c <num cache buffers>] [-z] -nowarnings -noautocommit

<<isql実行コマンド>>
SQL> help;
Frontend commands:
BLOBDUMP <blobid> <file>   -- dump BLOB to a file
BLOBVIEW <blobid>          -- view BLOB in text editor
EDIT     [<filename>]      -- edit SQL script file and execute
EDIT                       -- edit current command buffer and execute
HELP                       -- display this menu
INput    <filename>        -- take input from the named SQL file
OUTput   [<filename>]      -- write output to named file
OUTput                     -- return output to stdout
SET      <option>          -- (Use HELP SET for complete list)
SHELL    <command>         -- execute Operating System command in sub-shell
SHOW     <object> [<name>] -- display system information
    <object> = CHECK, DATABASE, DOMAIN, EXCEPTION, FILTER, FUNCTION, GENERATOR,
               GRANT, INDEX, PROCEDURE, ROLE, SQL DIALECT, SYSTEM, TABLE,
               TRIGGER, VERSION, VIEW
EXIT                       -- exit and commit changes
QUIT                       -- exit and roll back changes

All commands may be abbreviated to letters in CAPitals

SQL> help set;
Set commands:
    SET                    -- display current SET options
    SET AUTOddl            -- toggle autocommit of DDL statements
    SET BLOB [ALL|<n>]     -- display BLOBS of subtype <n> or ALL
    SET BLOB               -- turn off BLOB display
    SET COUNT              -- toggle count of selected rows on/off
    SET ECHO               -- toggle command echo on/off
    SET LIST               -- toggle column or table display format
    SET NAMES <csname>     -- set name of runtime character set
    SET PLAN               -- toggle display of query access plan
    SET PLANONLY           -- toggle display of query plan without executing
    SET SQL DIALECT <n>    -- set sql dialect to <n>
    SET STATs              -- toggle display of performance statistics
    SET TIME               -- toggle display of timestamp with DATE values
    SET TERM <string>      -- change statement terminator string
    SET WIDTH <col> [<n>]  -- set/unset print width to <n> for column <col>

All commands may be abbreviated to letters in CAPitals

↑