2
InterBase
: SQL InterBase.
InterBase , . InterBase , . IBConsole InterBase. / / InterBase.
, , , . Server / Register. Local Server, : User Name: SYSDBA, password: masterkey. Local Server . , Databases , .
Databases / Create Database, . . Filename Files , : D:\work\kts\301\Nitsenko\base1.gdb ( gdb). Size (Pages) , , 1000. Alias , , : MyBase1.
, . , , , Domains, Tables, Indexes .
SQL- InteractiveSQL (Tools / InteractiveSQL ).
InteractiveSQL SQL- , . Execute (Query / Execute ) . , insert, delete update, Transactions / Commit, Transactions / Rollback.
Query / Save Script ( ), - Query / Load Script ( ). , insert.
SQL
CREATE TABLE _
(_
[, _,..., ]
[ _ ]);
_ = _ _ [__ ] [ __ ]
|
|
__ = DEFAULT { | USER | NULL}
__ =
NOT NULL [UNIQUE | PRIMARY KEY]
| FOREIGN KEY REFERENCES __
| CHECK (___)
__ =
_
| _
| _
_ =
UNIQUE | PRIMARY KEY ( [, , ])
_ =
FOREIGN KEY () REFERENCES _ ()
_ =
CHECK (___)
ALTER TABLE _
ADD
ALTER TABLE _
DROP
DROP TABLE
DROP DATABASE
SQL InterBase. , . .
1. CREATE TABLE.
2. FOREIGN KEY REFERENCES?
3. PRIMARY KEY?
4. ALTER TABLE.
5. DROP.