18. How can you change "Hansen" into "Nilsen" in the "LastName" column in the Persons table? You answered: UPDATE Persons SET LastName='Nilsen' WHERE LastName='Hansen' Correct Answer! 19. With SQL, how can you delete the records where the "FirstName" is "Peter" in the Persons T...
ALTER COLUMN TheALTER COLUMNcommand is used to change the data type of a column in a table. The following SQL changes the data type of the column named "BirthDate" in the "Employees" table to type year: Example ALTERTABLEEmployees
The ALTER COLUMN command is used to change the data type of a column in a table.The following SQL changes the data type of the column named "BirthDate" in the "Employees" table to type year:Example ALTER TABLE EmployeesALTER COLUMN BirthDate year; Try it Yourself » DROP COLUMN...
The following SQL deletes the "ContactName" column from the "Customers" table:Example ALTER TABLE CustomersDROP COLUMN ContactName; Try it Yourself » ❮ SQL Keywords Reference Track your progress - it's free! Log in Sign Up COLOR PICKER PLUS...