3rd highest salary in sql server

Add a column, with a default value, to an existing table in SQL Server

Add a column, with a default value, to an existing table in SQL Server

Syntax:

ALTER TABLE TABLE_NAME
            ADD COL_NNAME COL_TYPE {NOT NULL OR NULL}
                        CONSTRAINT CONSTRAINT_NAME
                                    DEFAULT DEFAULT_VALUE
WITH VALUES

For example

ALTER TABLE CUSTOMER
            ADD NAME VARCHAR (255) NOT NULL
                        CONSTRAINT CUSTOMER_CONSTRAINT_NAME
                                    DEFAULT 'PENDING CUSTOMER'
WITH VALUES

In the above query "WITH VALUES" handles the "not null".

ANIL SINGH

Hey! I'm Anil Singh. I author this blog. I'm Active Blogger, Programmer. I love learning new technologies, programming, blogging and participating the forum discussions more...
http://www.code-sample.com
http://www.code-sample.xyz

You Might Also Like
Post a Comment
www.code-sample.com/. Powered by Blogger.