Flash cards
Review the key moves
1/4
Core idea
What is the main idea behind SQL DROP DEFAULT Keyword?
Lesson checks
Practice each idea before moving on
Short Mimo-style checks built from this lesson's code, terms, and sequence.
1Quick choice
Which statement best captures the main point of this lesson?
2Fill blank
Complete the missing token from the example code.
___ TABLE Persons3Order
Put the learning moves in the order that makes the concept easiest to apply.
SQL Server / Oracle / MS Access:
To drop a DEFAULT constraint, use the following SQL:
The DROP DEFAULT command is used to delete a DEFAULT constraint.
Drop Default
The DROP DEFAULT command is used to delete a DEFAULT constraint.
To drop a DEFAULT constraint, use the following SQL:
SQL Server / Oracle / MS Access:
ALTER TABLE Persons
ALTER COLUMN City DROP DEFAULT;MySQL
ALTER TABLE Persons
ALTER City DROP DEFAULT;