We can specify our own data type to use in the schema.
CREATE DOMAIN SSN AS CHAR(9);
CREATE TABLE DEPARTMENT (MGRSSN SSN, ...);We need to CREATE DOMAIN before utilising it in CREATE TABLE.
We can specify our own data type to use in the schema.
CREATE DOMAIN SSN AS CHAR(9);
CREATE TABLE DEPARTMENT (MGRSSN SSN, ...);We need to CREATE DOMAIN before utilising it in CREATE TABLE.