-- Which of the following is not a valid SQL Statement 

-- DELETE TABLE employees WHERE id = 1; 
-- Removes rows from the table based on a condition 

-- If you want to delete a specific row -- Use DELETE FROM 
-- If you want to remove the whole table -- DROP TABLE 

-- DROP VIEW 
DROP VIEW student_courses; 

-- DROP TABLE 
DROP TABLE Student; 

-- Delete the Office_Location column from the Department Table 
ALTER TABLE Department 
DROP COLUMN Office_Location; 

-- Modify the Office_Location column in the department table to increase its limit from 50 characters to 100 characters 
ALTER TABLE Department
MODIFY COLUMN Office_Location VARCHAR(100); 

-- Modify the program table to add a foreign key constraint on Department_ID, linking it to the department(Department_ID)
-- Column in the Department table 

ALTER TABLE Department 
ADD CONSTRIANT fk_Department 
FOREIGN KEY(Department_ID) REFERENCES Department(Department_ID);