How to get the equivalent of MySQL\'s DESCRIBE command in SQLite?

SQLite Equivalent to MySQL's DESCRIBE [table]

SQLite does not feature an exact equivalent to MySQL's DESCRIBE command. However, there is an alternative method for obtaining detailed information about a table:

Using the .schema Command

The SQLite command line utility provides a .schema command that allows you to view the create statements for a specified table. This information includes more details than the PRAGMA table_info [table] command.

To use the .schema command:

1. Open the SQLite command line utility.
2. Connect to the database containing the table you want to inspect.
3. Enter the following command:

.schema TABLENAME

where TABLENAME is the name of the table you want to inspect.

Example

Consider the following SQLite database containing a table named students:

CREATE TABLE students (
  id INTEGER PRIMARY KEY,
  name TEXT,
  age INTEGER,
  address TEXT,
  joined_date DATE
);

To view the create statement for the students table using the .schema command, execute the following query:

.schema students

This will output the following create statement:

CREATE TABLE students (
  id INTEGER PRIMARY KEY,
  name TEXT,
  age INTEGER,
  address TEXT,
  joined_date DATE
);

As you can see, the .schema command provides a more detailed view of the table structure, including the primary key and data types of each column.

The above is the detailed content of How to get the equivalent of MySQL\'s DESCRIBE command in SQLite?. For more information, please follow other related articles on the PHP Chinese website!