How to define a new field in an existing database?
For example, if an existing database contains the fields “firstname” and “lastname” how can I add (define) a new field such as “middlename”?
How to define a new field in an existing database?
For example, if an existing database contains the fields “firstname” and “lastname” how can I add (define) a new field such as “middlename”?
Hello @chorcher,
new fields can be added to an existing table by executing an SQL command such as:
ALTER TABLE "Table name" ADD "middlename" VARCHAR(127)
where “Table name” is the name of your existing table and 127 is the number of characters allowed for the Middle Name.