Hi,

Shortly I'll start deploying my first application using FB and here are few
questions I would ask:

1.
Probably there is no way to make further correction/addition of database
structure at customers side with help of programs such IBExpert or IBEasy
and it should be create/alter table used.
Using Create table. Looking at different documentation, I found different
usage of primary key generation:

CREATE TABLE TABLEA
(
FIELD1 VARCHAR(13) NOT NULL,
FIELD2 INTEGER NOT NULL,
FIELD3 INTEGER,
PRIMARY KEY (FIELD1, FIELD2)
);

and

CREATE TABLE TABLEA
(
FIELD1 VARCHAR(13) NOT NULL,
FIELD2 INTEGER NOT NULL,
FIELD3 INTEGER,
CONSTRAINT PK_TABLEA PRIMARY KEY (FIELD1, FIELD2)
);

Is here the only difference in defining a name for PK or ... ?

2.
How do you normaly handle, what to Create/Alter at customer side ?
When you develope new version of one deployed application, new data
structure is inside. Is it possible to know, which version of data structure
is in fdb file ? Or do you normaly refer to application version nr. ?



Regards,
Primoz