Saturday, 19 November 2011


The DEFAULT constraint is used to Insert a default value into a column.
The DEFAULT value will be automatic added to all records, if no other value is specified.

DEFAULT CONSTRAINT defined at only the Column level

Syntax:
Column_Name Datatype (size) DEFAULT 'Value'
Example Statement:
CREATE TABLE Student_Detail
(
S_No number(2) NOT NULL,
Name varchar(25) NOT NULL,
Address varchar(70),
City varchar(20) DEFAULT 'Ahmedabad'
);


0 comments:

Post a Comment

TrainingHUB. Powered by Blogger.

Total Pageviews

THE BEST QTP TRAINING INSTITUTE IN HYDERABAD

QTP Training in hyderabad

Sql Tutorial

Popular Posts

Our Facebook Page

TrainingHUB

Followers