Firebird数据库的中文参考资料（国外英文资料）.docVIP

Firebird数据库的中文参考资料（国外英文资料） Chinese reference for Firebird database of Firebird Noil firebird standard connection string Driver = Firebird/InterBase (r) Driver; Uid = SYSDBA. The Pwd = masterkey; DbName = C: \ document.and Settings \ Administrator \ desktop \ data \ demo. The default character set GBK; This sentence should be added in the creation of a database statement when using Chinese, and this is also used in the connection text. Net-firebird.net Data Provider connection string User = SYSDBA; Password = masterkey; The Database = SampleDatabase. FDB; The DataSource = localhost; Port = 3050; The Dialect = 3; Charset = NONE; Role =; The Connection lifetime = 15; Pooling = true; MinPoolSize = 0; MaxPoolSize = 50; Packet Size = 8192; ServerType = 0; In addition to the visible table, the noil Firebird hides the system tables that are specifically available (note that the text in the following statement is case-sensitive) Query all tables and views (including system tables and system views) SELECT RDB $RELATION_NAME FROM RDB $RELATIONS; In this way, we can see the system table at the beginning of the RDB $, such as the constraint information table: RDB $relation_constraints and its associated RDB $CHECK_CONSTRAINTS RDB $index_session A small example of pagination: Select first 10 templateid, code, name from template; Select first 10 templateid, code, name from template; Select * from shop rows 1 to 10; Firebird2.0 supports this approach Second, the show Show tables; Show the table tablename; Three, D: \ firebird 2 \ bin isql - u sysda-p masterkey Connect E: \ company \ xmwsoft \ newxmwsoft \ c2 \ db \ cts2.fdb Four -- update the field comments The update $RELATION_FIELDS RDB Set RDB $DESCRIPTION = DESCRIPTION information Where (RDB $RELATION_NAME = SHOP) and (RDB $FIELD_NAME = CREDIT_BUY) 5 - displays field comments Select RDB $FIELD_NAME, RDB $DESCRIPTION from RDB $RELATION_FIELDS Where (RDB $RELATION_NAME = SHOP) The and (RDB $FIELD_NAME = CREDIT_BUY) 6 -- update t