Complete SAS Programming Guide - Learn SAS and Become a Data Ninja - Altering Columns (Add, Modify, Delete, Add Values t

This video tutorial covers how to manage columns in SQL tables, including adding, modifying, and deleting columns. It explains the use of the ALTER TABLE statement to add a new column, update it with values, modify its properties, and finally drop it. The tutorial provides practical examples and emphasizes the simplicity of these SQL operations.

What is the first step in adding a new column to a SQL table?

• Use the DELETE statement

• Use the INSERT INTO statement

• Use the ALTER TABLE statement

• Use the SELECT statement

Which data type was used for the new column in the example?

• Boolean

• Character

• Date

• Numeric

Which SQL statement is used to apply a format to a new column?

• SELECT

• FORMAT

• UPDATE

• ALTER TABLE

How can you fill a new column with values based on existing columns?

• Using the UPDATE statement

• Using the INSERT statement

• Using the DELETE statement

• Using the SELECT statement

What is a potential use of the UPDATE statement as discussed in the video?

• To format a column

• To delete a table

• To calculate a tax column

• To create a new table

What operation is performed to change a column's label or format?

• ALTER TABLE SELECT

• ALTER TABLE MODIFY

• ALTER TABLE ADD

• ALTER TABLE DROP

What is the correct SQL command to remove a column from a table?

• ALTER TABLE DELETE

• ALTER TABLE ERASE

• ALTER TABLE REMOVE

• ALTER TABLE DROP