Resolved: Calling a Table with Database Name
I noticed a small difference in how we call the 'departments_dup' table when we ALTER it twice.
In the first one (Change dept_name constraint to allow NULL), we use:
ALTER TABLE departments_dup
but in the second ALTER (Add a dept_manager column), we use:
ALTER TABLE employees.departments_dup
I was just curious, is the 'employees.' before the table name necessary when we add a new column?