xxxxxxxxxx
CREATE TABLE my_table (
id INT PRIMARY KEY,
name VARCHAR(50) NOT NULL,
age INT DEFAULT 18
);
xxxxxxxxxx
ALTER TABLE table_name ALTER COLUMN column_name SET DEFAULT 'literal';
xxxxxxxxxx
CREATE TABLE table_name(
column_name data_type,
Column_name data_type DEFAULT ‘value’
);
xxxxxxxxxx
CREATE TABLE Persons (
ID int NOT NULL,
LastName varchar(255) NOT NULL,
FirstName varchar(255),
Age int,
Married boolean DEFAULT false);