# a. Add a column named full_name to this table. It should be a VARCHAR whose length is the sum of the lengths of the first name and last name columns ...

-- 1.a. Add a column named full_name to this table. It should be a VARCHAR whose length is the sum of the lengths of the first name and last name columns ALTER TABLE employees_with_departments ADD ...

To drop any columns in the new table, you can specify the DROP= data set option in the CREATE TABLE statement. The specified columns are dropped when the table is created. Indexes are not copied to ...

Temp table -temporary temp tables1)they can be created at run time in tempdb database.2)ddl,dml statements like select,update which can be executed on regular tables can be done on temporary tables.