|
The DEFAULT constraint provides a default value to a column when the INSERT INTO statement does not provide a specific value. For example, if we create a table as below:
CREATE TABLE Student
(Student_ID integer Unique,
Last_Name varchar (30),
First_Name varchar (30),
Score DEFAULT 80);
and execute the following SQL statement,
INSERT INTO Student (Student_ID, Last_Name, First_Name) values ('10','Johnson','Rick');
The table will look like the following:
| Student_ID | Last_Name | First_Name | Score |
| 10 | Johnson | Rick | 80 |
Even though we didn't specify a value for the "Score" column in the INSERT INTO statement, it does get assigned the default value of 80 since we had already set 80 as the default value for this column.
SQL Unique >>
Link to this page: If you find this page useful, we encourage you to link to this page. Simply copy and paste the code below to your website, blog, or profile.
Copyright © 2012 1keydata.com All Rights Reserved.
Privacy Policy
|