FrontPage > DataBase > 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
SYSDBA/masterkey
IPL(InterBase Public License)
私用・ビジネス使用共に完全にフリー。
FirebirdのPUKIWIKI(とても参考になるサイト)
http://nekomimi.s41.xrea.com/x/firebird/pukiwiki/?FrontPage
Firebird 関数
http://www.geocities.co.jp/SiliconValley-Sunnyvale/2497/firebird/firebird_function.htm