0
You visited us 0 times! Enjoying our articles? Unlock Full Access!
Question

Which of the following SQL statement is used to delete a column from a table ___________________.
  1. DELETE column-name from table name
  2. ALTER TABLE table name DROP COLUMN column name
  3. DROP column name FROM table name
  4. None of the above

A
None of the above
B
ALTER TABLE table name DROP COLUMN column name
C
DROP column name FROM table name
D
DELETE column-name from table name
Solution
Verified by Toppr

SQL statement is used to delete a column from a table.

ALTER TABLE table name DROP COLUMN column name.

ALTER TABLE statement to add a column, modify a column, drop a column, rename a column or rename a table.


The ALTER TABLE statement is also used to add and drop various constraints on an existing table.


Structured query language uses a collection of imperative verbs whose effect is to modify the schema of the database by adding, changing, or deleting definitions of tables or other elements.

Was this answer helpful?
0
Similar Questions
Q1
Which of the following SQL statement is used to delete a column from a table ___________________.
View Solution
Q2
In the following table, match the column B according to column A :

Column (A)Column (B)
(i)Pitch(a)waveform
(ii)Quality(b)Frequency
(iii)Loudness(c)Intensity

View Solution
Q3

Question 05
Prepare a table having two columns depicting names of endocrine glands and hormones secreted by them.


View Solution
Q4
Number of columns in a headed rows and numbered columns table gives :
View Solution
Q5

Question 05
Prepare a table having two columns depicting names of endocrine glands and hormones secreted by them.

View Solution