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.