How to add a new field to an existing database

One way to add new field is by executing an SQL command as below

ALTER TABLE "Table name" ADD "newfieldname" VARCHAR(127)


  • "Table name" = mean your existing  table name
  • "newfieldname" = the name of new field add
  • VARCHAR = field type for text
  • (127)= mean the number of character allow for the new field add