Category Archives: sqlite

SQLite – CREATE Database In SQLite, sqlite3 command is used to create a new SQLite database. You do not need to have any special privilege to create a database. Syntax Following is the basic syntax of sqlite3 command to create a database: − $sqlite3 DatabaseName.db Always, database name should be unique within the RDBMS. Example […]

SQLite – ATTACH Database Consider a case when you have multiple databases available and you want to use any one of them at a time. SQLite ATTACH DATABASE statement is used to select a particular database, and after this command, all SQLite statements will be executed under the attached database. Syntax Following is the basic […]

SQLite – Data Type SQLite data type is an attribute that specifies the type of data of any object. Each column, variable and expression has related data type in SQLite. You would use these data types while creating your tables. SQLite uses a more general dynamic type system. In SQLite, the datatype of a value […]