schreiben können: • Machen Sie sich zunächst klar, was es bereits gibt – niemand wartet auf drei Migrations-Anleitungen von MS-SQL zu Firebird. • Fragen Sie sich selbst, was fehlt und was hilfreich für angezeigt wird, wenn es auch vorhanden ist. Ist dies nicht der Fall wird title verwendet. Das gleiche Schema setzt sich für die Lesezeichen (die Navigation im linken Bereich) im PDF-Dokument fort. Info-Elemente

DATABASE Used for Creating a new database Available in DSQL, ESQL Syntax CREATE {DATABASE | SCHEMA} [ [ ...]] [ [ mode The CREATE DATABASE statement creates a new database. You can use CREATE DATABASE or CREATE SCHEMA. They are synonymous, but we recommend to always use CREATE DATABASE as this may change in a future database-wide configuration Available in DSQL, ESQL — limited feature set Syntax ALTER {DATABASE | SCHEMA} [ ...] :== | {ADD DIFFERENCE

Verwendet für Erstellen einer neuen Datenbank Verfügbar in DSQL, ESQL Syntax CREATE {DATABASE | SCHEMA} [ [ ...]] [ [ Die Anweisung CREATE DATABASE erstellt eine neue Datenbank. Sie können CREATE DATABASE oder CREATE SCHEMA verwenden. Sie sind synonym, aber wir empfehlen immer CREATE DATABASE zu verwenden, da sich dies Konfigurationen Verfügbar in DSQL, ESQL — eingeschränkter Funktionsumfang Syntax ALTER {DATABASE | SCHEMA} [ ...] :== | {ADD DIFFERENCE

PAGE, PAGE_SIZE, PAGES, PASSWORD, PRIVILEGES, PROTECTED, READ, RESERV, RESERVING, RETAIN, SCHEMA, SEGMENT, SHADOW, SHARED, SINGULAR, SIZE, SNAPSHOT, SORT, STABILITY, STARTING, STARTS, PASSWORD PRIVILEGES PROTECTED 22 Руководство по языку SQL READ RESERV RESERVING RESTRICT RETAIN ROLE SCHEMA SEGMENT SHADOW SHARED SINGULAR SIZE SNAPSHOT SORT STABILITY STARTING STARTS STATEMENT STATISTICS SQL DATABASE CREATE DATABASE Доступно: DSQL, ESQL Синтаксис (неполный): CREATE {DATABASE | SCHEMA} ... [PAGE_SIZE [=] size] ... [DEFAULT CHARACTER SET charset [COLLATION collation]] ... [DIFFERENCE

новой базы данных. Доступно в: DSQL, ESQL. Синтаксис: CREATE {DATABASE | SCHEMA} '' [USER username [PASSWORD 'password'] [ROLE rolename]] [PAGE_SIZE [=] size] [LENGTH Оператор CREATE DATABASE создаёт новую базу данных. Вы можете использовать CREATE DATABASE или CREATE SCHEMA. Это синонимы. База данных может состоять из одного или нескольких файлов. Первый, основной, файл изменение некоторых свойств базы данных. Доступно в: DSQL, ESQL. Синтаксис: ALTER {DATABASE | SCHEMA} { [ ...]} | {ADD DIFFERENCE FILE 'diff_file' | DROP DIFFERENCE

DATABASE Used for Creating a new database Available in DSQL, ESQL Syntax CREATE {DATABASE | SCHEMA} [USER 'username' [PASSWORD 'password']] [PAGE_SIZE [=] size] [LENGTH [=] num [PAGE[S]] files) The CREATE DATABASE statement creates a new database. You can use CREATE DATABASE or CREATE SCHEMA. They are synonymous. A database may consist of one or several files. The first (main) file is called Available in DSQL — both functions. ESQL — file reorganisation only Syntax ALTER {DATABASE | SCHEMA} [ [ ...]] [ADD DIFFERENCE FILE 'diff_file' | DROP DIFFERENCE

"" on table "" -531 335544597 dsql_crdb_prepare_err Cannot prepare a CREATE DATABASE/SCHEMA statement -532 335544469 trans_invalid Transaction marked invalid by I/O error -551 335544352 no_priv

are present for the record -531 335544597 dsql_crdb_prepare_err Cannot prepare a CREATE DATABASE/SCHEMA statement -532 335544469 trans_invalid Transaction marked invalid by I/O error -551 335544352 no_priv

are present for the record -531 335544597 dsql_crdb_prepare_err Cannot prepare a CREATE DATABASE/SCHEMA statement -532 335544469 trans_invalid Transaction marked invalid by I/O error Firebird 2.1 Error

database since its creation. Before making any more changes, create a new database with identical schema definitions or new ones, or create a new database source file. Using -m2 and -m(erge) The command