sql column default 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: how to check default value of column in sql server

SELECT object_definition(default_object_id) AS definition
FROM   sys.columns
WHERE  name      ='colname'
AND    object_id = object_id('dbo.tablename')

Tags:

Sql Example

Related