How Do I Retrieve Table Schema in MySQL?

Retrieving Table Schema in MySQL

When working with tables in a MySQL database, it's often necessary to view their schema. Fortunately, there are two convenient commands for this purpose:

1. describe

The describe command displays a formatted table showing the following information for each column:

• Name
• Data type
• Default value
• Null constraint
• Key constraint
• Extra information (e.g., auto-increment)

Example:

describe [db_name.]table_name;

2. show create table

The show create table command provides an SQL statement that can be used to re-create the table. This command is useful for performing backups or creating new tables with similar structure.

Example:

show create table [db_name.]table_name;

By using either of these commands, you can easily view and retrieve the schema of a table in a MySQL database.

The above is the detailed content of How Do I Retrieve Table Schema in MySQL?. For more information, please follow other related articles on the PHP Chinese website!