Default value in Create table.

Database

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
N/A

Re: Default value in Create table.

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

Dieter

Re: Default value in Create table.

:(

In Oracle , we can do it that way.

Anyways thanks Dieter.