Default value in Create table.

Database
Enthusiast

Default value in Create table.

I want to create a table like

create table mytable

(

col1 date default sysdate-1

)

in teradata.

CAn anybody please suggest??

2 REPLIES
Junior Contributor

Re: Default value in Create table.

I'm afraid you can't, there's just DATE or CURRENT_DATE, but no calculation allowed.

Dieter

Enthusiast

Re: Default value in Create table.

:(

In Oracle , we can do it that way.

Anyways thanks Dieter.