![]() The command works the same as LIKE operator. tables pattern Code language: SQL (Structured Query Language) ( sql ) If you want to show tables with the specific name, you can add a matching pattern. The following shows the output: albums employees invoices playlistsĪrtists genres media_types temp.temp_table1Ĭustomers invoice_items playlist_track tracks Code language: SQL (Structured Query Language) ( sql )īecause the schema of temporary tables is temp, the command showed the names of schema and table of the temporary table such as temp.temp_table1. ![]() tables Code language: SQL (Structured Query Language) ( sql ) Second, list all tables from the database. See the following example:įirst, create a new temporary table named temp_table1: CREATE TEMPORARY TABLE temp_table1( name TEXT ) Code language: SQL (Structured Query Language) ( sql ) tables command also can be used to show temporary tables. tables command lists all tables in the chinook database albums employees invoices playlistsĬustomers invoice_items playlist_track Code language: SQL (Structured Query Language) ( sql ) tables command: tables Code language: SQL (Structured Query Language) ( sql ) The above statement opened the database named chinook.db that locates in the c:\sqlite\db directory. To show tables in a database using the sqlite command-line shell program, you follow these steps:įirst, open the database that you want to show the tables: sqlite3 c:\sqlite\db\chinook.db Code language: SQL (Structured Query Language) ( sql ) Showing tables using the sqlite command line shell program ![]() Summary: in this tutorial, you will learn various ways to show tables from an SQLite database by using the SQLite command-line shell program or by querying data from sqlite_master tables.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |