Command for viewing the MySQL table structure

What command should I use to view the Mysql table structure? The following describes the commands for viewing the Mysql table structure in detail. If you have encountered a similar problem in the Mysql table organization, you may wish to take a look.

Run the following command to view the Mysql table structure:

Desc table name;
Show columns from table name;
Describe table name;
Show create table name;

Use information_schema
Select * from columns where table_name = 'table name ';

By the way:
Show databases;
Use Database Name;
Show tables;

The original unique index AK_PAS_Name (PAC_Name) is in the tb_webparamcounter table,
Run the following SQL statement to modify the index:
Alter table tb_webparamcounter drop index AK_PAS_Name;
Alter table tb_webparamcounter add UNIQUE AK_PAS_Name (PC_ID, PAC_Name );

If you find that the index logic is incorrect, you need to add another field to execute
Alter table tb_webparamcounter drop index AK_PAS_Name;
Alter table tb_webparamcounter add UNIQUE AK_PAS_Name (PC_ID, PAC_Name, PAC_Value );
Note: The PC_ID, PAC_Name, and PAC_Value fields are not FOREIGN keys.
Otherwise, you must first drop foreign key and then redo the previous step.

By the way, oracle
Select * from v $ database;
Select * from all_users;
Select * from user_tables