D?? SQL Формат операторов ?? E2 стр. по D86E строкD ?? EфайлD hsql ??E
??DОпределенияE CREATE, DROP, DATABASE, ALTER, RENAME ??
??DМанипуляцииE DELETE, INSERT, UPDATE, LOAD/UNLOAD ??
?? SELECT and UNION statements. ??
??DДоступаE GRANT/REVOKE, LOCK/UNLOCK, SET LOCK MODE ??
??DВосстановленияE Transaction, Audit trail ??
??DПрочиеE CHECK, REPAIR, INFO, OUTPUT, SET EXPLAIN ??
?'?'?'?'?'?'?'?'?'?'?'?'?'?'?'?'?'?'?'?'?'?'?'?'?'?'?'?'?'?'?'?'?'?'?'?'?'?'?'?'?'?'?'?'?'?'?'?'?'?'?'?'?'?'?'?'?'?'?'?'?'?'?'
D???'?'?'?'?'?'?'?'?'?'?'?'?'?'?'?'?'?'?'?'?'?'?'?'?'?'?'?'?'?'?'?'?'?'?'?'?'?'?'?'?'?'?'?'?'?'?'?'?'?'?'?'?'?'?'?'?'?'?'?'E
D??Definition CREATE, DROP, DATABASE, ALTER, RENAME ??E
D??E Операторы определения данных не откатываются D??E
D???'?'?'?'?'?'?'?'?'?'?'?'?'?'?'?'?'?'?'?'?'?'?'?'?'?'?'?'?'?'?'?'?'?'?'?'?'?'?'?'?'?'?'?'?'?'?'?'?'?'?'?'?'?'?'?'?'?'?'?'E
DCREATE DATABASEE database [WITH LOG IN "pathname" [MODE ANSI]]
DDROP DATABASEE database-name стандарт ansi = требует
имя владельца, транзакция по умолчнию
DDATABASEE database-name [EXCLUSIVE] сделать текущей
DCLOSE DATABASEE
DCREATEE [TEMP] DTABLEE table-name ( column-name datatype [NOT NULL]
[UNIQUE [CONSTRAINT constr-name]][,...] )
[UNIQUE(uniq-col-list) [CONSTRAINT constr-name]][,..]
[WITH NO LOG]
[IN "pathname-directory"]
DATA TYPES
INTEGER SERIAL[(n0)] - автоматический счетчик
SMALLINT CHAR(n) DATE
FLOAT DECIMAL(m,n) DATETIME qualif1 TO qualif2
REAL MONEY(m,n) INTERVAL qualif1 TO qualif2
где qualifier Ё {YEAR,MONTH,DAY,HOUR,MINUTE,SECOND,FRACTION(n)}
DALTER TABLEE table-name
{ ADD ( new-column-name datatype [NOT NULL]
[UNIQUE [CONSTRAINT constr-name]][,...] )
| [BEFORE old-column-name]
DROP (old-column-name[,...])
|
MODIFY (old-column-name new-datatype [NOT NULL][,...])
|
ADD CONSTRAINT UNIQUE (old-column-name[,...])
| [CONSTRAINT constr-name]
DROP CONSTRAINT (constr-name[,...]) } [,...]
DCREATE VIEWE view-name [(column-list)]
AS SELECT-statement [WITH CHECK OPTION]
DCREATEE [UNIQUE|DISTINCT] [CLUSTER] DINDEXE index-name
ON table-name (column-name [DESC], ...)
DALTER INDEXE index-name TO [NOT] CLUSTER Cтроки в порядке индекса
CREATE SCHEMA AUTHORIZATION username {create and/or grant statements}
Примечание: подчеркнутые операторы нельзя использовать в 4GL
DCREATE SYNONYME synonym-name FOR table-name
DDROP INDEXE index-name
DDROP SYNONYME synonym-name
DDROP TABLEE table-name
DDROP VIEWE view-name
DRENAME TABLEE old-table-name TO new-table-name
DRENAME COLUMNE table.old-column-name TO new-column-name
D???'?'?'?'?'?'?'?'?'?'?'?'?'?'?'?'?'?'?'?'?'?'?'?'?'?'?'?'?'?'?'?'?'?'?'?'?'?'?'?'?'?'?'?'?'?'?'?'?'?'?'?'?'?'?'?'?'?'?'?'E
D?? Manipulation DELETE, INSERT, UPDATE, LOAD, UNLOAD ??E
D???'?'?'?'?'?'?'?'?'?'?'?'?'?'?'?'?'?'?'?'?'?'?'?'?'?'?'?'?'?'?'?'?'?'?'?'?'?'?'?'?'?'?'?'?'?'?'?'?'?'?'?'?'?'?'?'?'?'?'?'E
DDELETE FROME table-name [WHERE condition]
DINSERT INTOE table-name [(column-list)]
{ VALUES (value-list) | SELECT-statement }
DUPDATEE table-name DSETE {column-name ={ expression | (SELECT-st) } [,...] |
{(col-list) | [table.]*} =
{ ({ expr-list | (SELECT-st) } [,...]) | record-name.* }
[WHERE condition]
DLOAD FROME "file" [DELIMITER "?"] INSERT INTO table [(col-list)]
DUNLOAD TOE "file" [DELIMITER "?"] SELECT-statementD???'?'?'?'?'?'?'?'?'?'?'?'?'?'?'?'?'?'?'?'?'?'?'?'?'?'?'?'?'?'?'?'?'?'?'?'?'?'?'?'?'?'?'?'?'?'?'?'?'?'?'?'?'?'?'?'?'?'?'?'E
D?? Select The SELECT and UNION statements. ??E
D???'?'?'?'?'?'?'?'?'?'?'?'?'?'?'?'?'?'?'?'?'?'?'?'?'?'?'?'?'?'?'?'?'?'?'?'?'?'?'?'?'?'?'?'?'?'?'?'?'?'?'?'?'?'?'?'?'?'?'?'E
DSELECTE [UNIQUE] select-list
[FROM { [OUTER] tabname [tab-alias] |
OUTER (table-expr) } [,...] ]
[WHERE condition]
[GROUP BY column-list] [HAVING condition]
[ORDER BY column-name [DESC],...]
[INTO TEMP table-name]
SELECT-statement UNION [ALL] SELECT-statement [. . .]
WHERE conditions:
связанные логическими операторами OR, AND, NOT сравнения
expr rel-op expr где rel-op из >,<,>=,<=,<>,!=
column-name IS [NOT] NULL
expr [NOT] BETWEEN ... AND ...
expr [NOT] IN (.. , .. [, ...] )
по умолчанию "\"
string [NOT] LIKE "шаблон" [ESCAPE "escape-char"]
спецсимволы шаблона D%E D_E означают │ !
string [NOT] MATCHES "шаблон" [ESCAPE "esc-char"]
спецсимволы шаблона D*E D?E D[EabHD]E D[^EdD-EzD]E означают │ ! Ё ©
expr rel-op {ALL | [ANY | SOME]} (SELECT-statement)
expr [NOT] IN (SELECT-statement) !* Обыкновенный *!
[NOT] EXISTS (SELECT-statement) !* SQLевский *!
D???'?'?'?'?'?'?'?'?'?'?'?'?'?'?'?'?'?'?'?'?'?'?'?'?'?'?'?'?'?'?'?'?'?'?'?'?'?'?'?'?'?'?'?'?'?'?'?'?'?'?'?'?'?'?'?'?'?'?'E
D??Access GRANT/REVOKE, LOCK/UNLOCK, SET LOCK MODE ??E
D???'?'?'?'?'?'?'?'?'?'?'?'?'?'?'?'?'?'?'?'?'?'?'?'?'?'?'?'?'?'?'?'?'?'?'?'?'?'?'?'?'?'?'?'?'?'?'?'?'?'?'?'?'?'?'?'?'?'?'E
{DBpriv {PUBLIC право давать права
DGRANTE | TO | [WITH GRANT OPTION] [AS grantor]
TBpriv ON table} user-list} от чужого имени
{DBpriv {PUBLIC
DREVOKEE | FROM |
TBpriv ON table} user-list}
TABLE PRIVILEGES:
DATABASE PRIVILEGES: ALTER DELETE
INDEX INSERT
CONNECT SELECT[(cols)]
RESOURCE UPDATE [(cols)]
DBA ALL [PRIVILEGES]
DSET LOCK MODEE TO [NOT] WAIT ждать /не ждать освобождения
DLOCK TABLEE table-name IN {SHARE | EXCLUSIVE} MODE
DUNLOCK TABLEE table-name {Можно смотреть | Ничего нельзя }
D???'?'?'?'?'?'?'?'?'?'?'?'?'?'?'?'?'?'?'?'?'?'?'?'?'?'?'?'?'?'?'?'?'?'?'?'?'?'?'?'?'?'?'?'?'?'?'?'?'?'?'?'?'?'?'?'?'?'?'?'E
D??Integrity Transaction, Audit trail ??E
D???'?'?'?'?'?'?'?'?'?'?'?'?'?'?'?'?'?'?'?'?'?'?'?'?'?'?'?'?'?'?'?'?'?'?'?'?'?'?'?'?'?'?'?'?'?'?'?'?'?'?'?'?'?'?'?'?'?'?'?'E
Проводить транзакцию с новым LOG файлом
DSTART DATABASEE database WITH LOG IN "/pathname" [MODE ANSI]
DDATABASEE database-name [EXCLUSIVE]
DROLLFORWARD DATABASEE database-name Восстановить базу
DCLOSE DATABASEE из backup-копии
DBEGIN WORKE Начало транзакции Внимание, все измененные
. . . строки локируются!!
DCOMMIT WORKE Koнец транзакции
DROLLBACK WORKE Откатить изменения к предыдущему COMMIT
DCREATE AUDITE FOR table-name IN "pathname"
. . .
DRECOVER TABLEE table-name Восстановить таблицу
DDROP AUDITE FOR table-name
D???'?'?'?'?'?'?'?'?'?'?'?'?'?'?'?'?'?'?'?'?'?'?'?'?'?'?'?'?'?'?'?'?'?'?'?'?'?'?'?'?'?'?'?'?'?'?'?'?'?'?'?'?'?'?'?'E
D??Auxiliary CHECK, REPAIR, INFO, OUTPUT, SET EXPLAIN??E
D???'?'?'?'?'?'?'?'?'?'?'?'?'?'?'?'?'?'?'?'?'?'?'?'?'?'?'?'?'?'?'?'?'?'?'?'?'?'?'?'?'?'?'?'?'?'?'?'?'?'?'?'?'?'?'?'E
CHECK TABLE table-name Проверить индексы
REPAIR TABLE table-name Ремонт индексов
Примечание: подчеркнутые операторы нельзя использовать в 4GL
INFO {TABLES | COLUMNS FOR table-name
| INDEXES FOR table-name | STATUS FOR table-name
| {ACCESS | PRIVILEGES} FOR table-name}
DUPDATE STATISTICSE [FOR TABLE table-name] системном каталоге
DSET EXPLAINE {ON | OFF} Включить системные об`яснения
Популярность: 4, Last-modified: Thu, 12 Feb 1998 08:48:26 GMT