5.6. VIEW. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 129 5.6.1. CREATE VIEW . . . 6.2. ALTER VIEW . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 133 5.6.3. CREATE OR ALTER VIEW . . . . . 5.6.4. DROP VIEW . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 135 5.6.5. RECREATE VIEW . . . . . . .

5.6. VIEW. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 163 5.6.1. CREATE VIEW . . . 6.2. ALTER VIEW . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 167 5.6.3. CREATE OR ALTER VIEW . . . . . 5.6.4. DROP VIEW . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 169 5.6.5. RECREATE VIEW . . . . . . .

................ 143 VIEW ...................................................................................................................................... 144 CREATE VIEW ..................... ...................................................................................... 146 ALTER VIEW ................................................................................................. ............................................................................ 150 CREATE OR ALTER VIEW ........................................................................................... 150 Примеры

5.6. VIEW. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 150 5.6.1. CREATE VIEW . . . 6.2. ALTER VIEW . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 155 5.6.3. CREATE OR ALTER VIEW . . . . . 5.6.4. DROP VIEW . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 157 5.6.5. RECREATE VIEW . . . . . . .

TRIGGER CREATE OR ALTER TRIGGER DROP TRIGGER RECREATE TRIGGER VIEW CREATE VIEW ALTER VIEW CREATE OR ALTER VIEW RECREATE VIEW 7. Операторы DML DELETE Использование COLLATE для столбцов с Список столбцов для представлений с оператором UNION теперь не обязателен • ALTER VIEW • CREATE OR ALTER VIEW 15 Руководство по языку SQL Язык обращения с данными (DML) Изменения начиная с Firebird | EXTERNAL FUNCTION | FILTER | GENERATOR | INDEX | PROCEDURE | ROLE | SEQUENCE | TABLE | TRIGGER | VIEW Замечание Если Вы вводите пустой комментарий (''), то он будет сохранён в базе данных как NULL.

of read-only table -150 335544362 read_only_view Cannot update read-only view @1 -150 335544446 non_updatable Not updatable -150 335544546 constaint_on_view Cannot define constraints on views -151 335544359 335544658 dsql_base_table @1 is not a valid base table of the specified view -157 335544598 specify_field_err Must specify column name for view select expression -158 335544599 num_field_err Number of columns twice in view; use an alias Firebird 2.1 Error Codes to distinguish -282 335544660 view_alias View @1 has more than one base table; use aliases to distinguish -282 335544710 complex_view Navigational

of read-only table -150 335544362 read_only_view Cannot update read-only view %s -150 335544446 non_updatable Not updatable -150 335544546 constaint_on_view Cannot define constraints on views -151 335544359 335544658 dsql_base_table %s is not a valid base table of the specified view -157 335544598 specify_field_err Must specify column name for view select expression -158 335544599 num_field_err Number of columns is referenced twice in view; use an alias to distinguish -282 335544660 view_alias View %s has more than one base table; use aliases to distinguish -282 335544710 complex_view Navigational stream %ld

read-only table -150 335544362 read_only_view Cannot update read-only view -150 335544446 non_updatable Not updatable -150 335544546 constaint_on_view Cannot define constraints on views -151 dsql_base_table is not a valid base table of the specified view -157 335544598 specify_field_err Must specify column name for view select expression -158 335544599 num_field_err Number of columns referenced twice in view; use an alias to distinguish -282 335544660 view_alias View has more than one base table; use aliases to distinguish -282 335544710 complex_view Navigational stream

updatable via triggers no longer perform direct table operations In former versions, a naturally updatable view with triggers passed the DML operation to the underlying table and executed the triggers as well. to, updated or deleted from the underlying table), the operation was done twice: once executing the view's trigger code and again executing the table's trigger code. This situation caused performance problems triggers for a naturally updatable view, it becomes effectively like a non-updatable view that has triggers to make it updatable, in that a DML request has to be defined on the view to make the operation on the

the DML in the script that caused the problem. When the server only indicates failure, users can view the first line of the statement that caused the failure, in relation to the entire script. This to extract the information to a specified output file. The resultant information can be used to view all the changes made to the database since its creation. Before making any more changes, create a Frontend commands: BLOBDUMP -- dump BLOB to a file BLOBVIEW -- view BLOB in text editor EDIT [] -- edit SQL script file and execute EDIT