Describe the format of the ALTER TABLE command to add a new column.

What will be an ideal response?


To add a new column, use the ADD clause of the ALTER TABLE command. The format for the command is the words ALTER TABLE followed by the name of the table to be altered, followed by an appropriate clause.The ADD clause consists of the word ADD followed by the name of the column to be added, followed by the characteristics of the column.

Computer Science & Information Technology

You might also like to view...

In addition to archiving email messages, Outlook provides ____ tools to help control the size of your mailbox.

A. cleanup B. analytical C. website D. deletion

Computer Science & Information Technology

Files with the ________ extension are formatted as the creator intended and read only and readable by a free downloadable program

Fill in the blank(s) with correct word

Computer Science & Information Technology

Whenever a Web client visits a Web server, saved ____ for the requested Web page are sent from the client to the server.

A. forms B. fields C. cookies D. identifiers

Computer Science & Information Technology

Which of the following is the topmost node in a tree and does not have a parent?

A. root B. child C. leaf D. interior node

Computer Science & Information Technology