Correct Answer: ALTER TABLE table_name DROP COLUMN column_name
Explanation:
Note: This Question is unanswered, help us to find answer for this one
SQL Skill Assessment
Your Skill Level: Poor
Retake Quizzes to improve it
More SQL MCQ Questions
Consider two tables A and B having only one column each and having these values:
A = [0, 1, 2, 3, 4, 5]
B = [5, 6, 7, 8, 9, 10]
The number of records in result of UNION operator on these tables will be?
Transactions, if available, wrap ___ operations.
Which of the following is the name of ** operator?
Which of the following functions are related to XML? (check any that apply)
Suppose you have the following table with columns:
+------+------+------------+--------------------+
| id | name | work_date | salary |
| 1 | John | 2016-01-24 | 300 |
To get an output like '1John2016-01-24' which of the following functions can be used?
Which character is used to retrieve all columns of data?
Which of the following is NOT a basic SQL statement?
Which character is used to end a SQL statement?
True or False: An ORDER BY clause is optional in a query.
Of the following sequences which one is in the correct order?