Table related interview question

Ques:- How to create table into mysql server?
Ans:- CREATE TABLE table_name (column_name column_type);
Example:-

CREATE TABLE employee(name VARCHAR(20), address VARCHAR(20));

Ques:- How To see all the tables from a database?
Ans:- show tables

Ques:-How to see table’s field formats or description of table?
Ans:- describe tablename

Ques:-How to delete a table?
Ans:- drop table tablename

Ques:-How you will Show all data from a table?
Ans:- SELECT * FROM tablename