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...

Show the student roster (use the format: , in a single column) for each section that Todd Smythe teaches. Identify the section using course number AND section number.

What will be an ideal response?

Computer Science & Information Technology

Consider an entity type SECTION in a UNIVERSITY database, which describes the section offerings of courses. The attributes of SECTION are SectionNumber, Semester, Year, CourseNumber, Instructor, RoomNo (where section is taught), Building (where section is taught), Weekdays (domain is the possible combinations of weekdays in which a section can be offered {MWF, MW, TT, etc.}). Assume tat SectionNumber is unique for each course within a particular semester/year combination (that is, if a course if offered multiple times during a particular semester, its section offerings are numbered 1, 2, 3, etc.). There are several composite keys for SECTION, and some attribute sare components of more than one key. Identify three composite keys, and show how they can be represented in an ER schema diagram.

What will be an ideal response?

Computer Science & Information Technology

The ________ was the first portable computer

A) Apple Macintosh B) Intel C) IBM PC D) Osborne

Computer Science & Information Technology

Where are screenshots saved?

A) Folder called Screenshots in the Documents folder B) Folder called Screenshots in the Downloads folder C) As a document on drive C, not in any folder D) Folder called Screenshots in the Pictures Library

Computer Science & Information Technology