Open In App
Related Articles

SQL | CREATE DOMAIN

Improve
Improve
Improve
Like Article
Like
Save Article
Save
Report issue
Report
Used in : Postgre sql CREATE DOMAIN creates a new domain. A domain is essentially a data type with optional constraints (restrictions on the allowed set of values). The user who defines a domain becomes its owner. Domains are useful for abstracting common constraints on fields into a single location for maintenance. For example, several tables might contain email address columns, all requiring the same CHECK constraint to verify the address syntax. Define a domain rather than setting up each table’s constraint individually. Examples:
CREATE DOMAIN CPI_DATA AS REAL CHECK
(value >= 0 AND value <= 10);
Now CPI_DATA domain is create so, we can use this domain anywhere in any table of database as below :
CREATE TABLE student(
sid char(9) PRIMARY KEY,
name varchar(30),
cpi CPI_DATA
);
Every time cpi_data will check the constraint, when you add data in student table. Example 1 :
Insert into student values (201501408,Raj,7.5); 
This will not violate the property of cpi. 
Example 2 :
Insert into student values (201501188,Dhaval,12); 
ERROR. This will violate the property of cpi. 

Last Updated : 07 Sep, 2018
Like Article
Save Article
Previous
Next
Share your thoughts in the comments
Similar Reads