Menu
Home / CSE / SQL Basics :: Discussion

Discussion :: SQL Basics

  1. In SQL, which command(s) is(are) used to change a table's storage characteristics?

    2. A.

     ALTER TABLE
    B.

     MODIFY TABLE
    C.

     CHANGE TABLE
    D.

     All of the above

    View Answer

    Workspace

    View Answer

    Answer : Option A

    Explanation :

    To change the structure of the table we use ALTER TABLE.
    Sytax:
    ALTER TABLE "table_name"
    ADD "column_name" datatype

    OR

    ALTER TABLE "table_name"
    DROP COLUMN "column_name"
    etc..

Write your comments here:

Be The First To Comment