We use ALTER command to do this:
ALTER TABLE table_name
DROP COLUMN column_name;
What is SQL?
What is the use of the select statement in the SQL?
How we insert the data inside the table?
How many clause we have in SQL?
What the work of the GROUP clause?
What is the use of ALTER command?
Write query to add new column in the table.
How we delete the existing column from the table?
How we change the name of the column of the table in SQL?
How we change the name of the table in the SQL?
What is RENAME command in SQL?
Different type of language in the DBMS?
What is DDL in DBMS?
What is DCL in DBMS?
What is DML in DBMS?
What is VIEW in SQL?
What is the difference between the Truncate, DROP, delete?
What is DROP command in SQL?
If we have a two table of same structure and same column and we want to fetch common record from both the table then what we do?
How we get the maximum value of the column of the table?
How find the MAX and Second max value from the database table?
How fetch top 5 record of the table?
How fetch the data from the table which do not have duplicate data.
MySQL Interview Questions ans Answers
Normalization Interview Question
Interview Question on SQL Query