# Creating/Modifying a SQLite Database Without Designer

It is possible to create and/or modify a SQLite database with another program besides Designer. However, if this is going to be done, the following guidelines should be followed:

- When naming your database, tables, queries and stored procedures, ensure that following are observed:
- Names should always start with a letter.
- Characters to be used are: A-Z, a-z, 0-9 and the underscore character (_).

- When creating data types, ensure that data type mapping is observed (using the wrong data type names may result in the database not working):

  Designer | SQLite
  --- | ---
  Boolean | bit
  Integer | int
  Double | float
  String | text
  DateTime | datetime

  Note:

  In addition, the following should be followed:

  - Do not use Scale or Precision.
  - Do not set a length for String or text.
  - Byte can be used instead of bit.
  - Float or double can be used interchangeably.
- A field can be "not null"; however, be prepared to deal with an error if a value is not provided.
- Default values can be assigned to a field.
- An index can be added.