Hello, I'm creating a table and I need to leave the expiration date as default on the date 1990/01/01. Could someone help me?
Below the code I've created.
create table Coordenador (
ID int NOT NULL identity(1,1)
,idlogin varchar(30) not null
,senha varchar(15) not null
,Nome varchar(30) not null
,Email varchar(100) not null
,Celular varchar(14) not null
,DtExpiracao date default getdate()
,constraint PK_Coordenador
primary key (ID)
,constraint AK_login UNIQUE(idlogin)
,constraint AK_Email unique(email)
,constraint AK_Celular unique(celular)
);
go