SQLite has many built-in functions to perform processing on string or numeric data. Following is the list of few useful SQLite built-in functions and all are case in-sensitive which means you can use these functions either in lower-case form or in upper-case or in mixed form. For more details, you can check official documentation for SQLite.
![]() ![]() ![]()
Unlike SQL-standard and other database systems, SQLite supports a very limited functionality of the ALTER TABLE statement. By using an SQLite ALTER TABLE statement, you can perform two actions: Rename a table. Add a new column to a table. SQLite ALTER TABLE – Renaming a table. To rename a table, you use the following ALTER TABLE RENAME TO statement.
![]() Comments are closed.
|
AuthorWrite something about yourself. No need to be fancy, just an overview. Archives
March 2023
Categories |