AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |
Back to Blog
Sqlite list tables python1/2/2024 ![]() A SQL statement like a SELECT statement can be executed on the SQLite server by calling the execute() method of the cursor object and passing the SQL statement as parameter.Through the connection object a sqlite3.Cursor object can be obtained.A database connection to an SQLite database can be created by calling the connect() method of the sqlite3 module.The sqlite3 is the python database client for SQLite database.Getting the list of tables and indexes present in a SQLite database using Python: The sql column of the sqlite_master table contains the SQL statement with which a table or index has been created.The type column will hold the value "table" for a database table and the value "index" for a database index. The type column of the sqlite_master table denotes what type of database object the record is about. ![]()
0 Comments
Read More
Leave a Reply. |