SQL DEFAULT Keyword

DEFAULT Keyword

Previous

Next

Default

The DEFAULT

SQL DEFAULT on CREATE TABLE

My SQL / SQL Server / Oracle / MS Access:

CREATE TABLE Persons

City varchar(255) DEFAULT 'Sandnes'

);
The DEFAULT constraint can also be used to insert system values, by using functions like GETDATE():

CREATE TABLE Orders

OrderDate date DEFAULT GETDATE()

);

SQL DEFAULT on ALTER TABLE

MySQL:

ALTER TABLE Persons

ALTER City SET DEFAULT 'Sandnes';

SQL Server:

ALTER TABLE Persons

ADD CONSTRAINT df_City
DEFAULT 'Sandnes' FOR City;

MS Access:

ALTER TABLE Persons

ALTER COLUMN City SET DEFAULT 'Sandnes';

Oracle:

ALTER TABLE Persons

MODIFY City DEFAULT 'Sandnes';

DROP a DEFAULT Constraint

MySQL:

ALTER TABLE Persons

ALTER City DROP DEFAULT;

SQL Server / Oracle / MS Access:

ALTER TABLE Persons

ALTER COLUMN City DROP DEFAULT;

Previous