sql server create table default value code example

Example 1: set default column value sql

Name Varchar(255) default "Fred"

Example 2: add column alter table default value

ALTER TABLE PERSON
ADD IS_ACTIVE VARCHAR2(1) DEFAULT 'N' NOT NULL

Example 3: sql server create table column default value constraint name

CREATE TABLE dbo.doc_exz (
      column_a INT,
      column_b INT CONSTRAINT DF_Doc_Exz_Column_B DEFAULT 50);

Tags:

Sql Example

Related