Jet MS Access.
Create Table . , . , . , , , . () Primary Key, Unique, Reference.
CREATE TABLE
( LONG CONSTRAINT PRIMARY KEY,
CHAR(15), CHAR (20),
CHAR (20), DATETIME,
CONSTRAINT
REFERENCE (, ,))
Create Index , MS Access. . ( Unique). , , , , , PRIMARY DISALLOWNULL IGNORENULL.
CREATE INDEX ON () WITH DISALLOW NULL
Alter Table , , . .
ALTER TABLE ADD COLUMN TEXT(6), TEXT(10)
ALTER TABLE DROP COLUMN
ALTER TABLE ADD CONSTRAINT UNIQUE ()
ALTER TABLE DROP CONSTRAINT
Drop , , , .
DROP TABLE
DROP INDEX ON
DROP PROCEDURE
DROP VIEW
,
SQL Open RecordSet, .. .
DDL , , -: Execute Command.
Dim cmd As New ADODB.Command
cmd.ActiveConnection = adoconn '
cmd.CommandText = "CREATE TABLE Strnakl (Tovar LONG, Kvo LONG DEFAULT 1)"
cmd.Execute
Jet 4.0 ANSI-92
MS Access 2000 Jet 4.0, ANSI-92. , , .
CREATE TABLE DEFAULT , . . , 1.
Dim cmd As New ADODB.Command
cmd.ActiveConnection = adoconn '
|
|
cmd.CommandText = _
"CREATE TABLE Strnakl (Tovar LONG, Kvo LONG DEFAULT 1)"
cmd.Execute
????
.
, . , , (, ). , , , . .
, .. - . , , .
, , , , .. . ( ). , , . , . .
, . , (, ) . , , , . Microsoft Jet, . , Jet.