COALESCE in create table?

Database
Enthusiast

COALESCE in create table?

Hi,

Can someone please table whether we can provide coalesce for a column while creating table.

I have seen cases where you select using coalesce but could not find anywhere within create table

Thanks,

Sunitha






1 REPLY
Teradata Employee

Re: COALESCE in create table?

Hi,

there is a DEFAULT attibute for columns to provide a default value, if that's what you need.

With kind regards,

Vlad.