alter table add default sql

ALTER TABLE users
ADD visit_number INT DEFAULT 0;

// For SQL Server

ALTER TABLE Persons
ADD CONSTRAINT df_City
DEFAULT 'Sandnes' FOR City;

Name Varchar(255) default "Fred"

CREATE TABLE Persons
(

    ID int NOT NULL,

   
LastName varchar(255) NOT NULL,

   
FirstName varchar(255),

   
Age int,

   
City varchar(255) DEFAULT 'Sandnes'

);