Is it possible to add NO FALLBACK to a view?

Database
Enthusiast

Is it possible to add NO FALLBACK to a view?

Hi experts!

 

Is it possible to add NO FALLBACK to a view? I didn't find any reference about it.

 

When checking ProtectionType column in dbc.tables, I noticed the value set to the view is 'F'.

 

Capture111.PNG

It may be a misconception about fallback, but I really would appreciate some help about it.

 

Thanks!

2 REPLIES
Teradata Employee

Re: Is it possible to add NO FALLBACK to a view?

Views are virtual, they do not store data. So fallback does not apply to a view.
Senior Apprentice

Re: Is it possible to add NO FALLBACK to a view?

Of course there's no Fallback for views (there's no data in it), it's just set to a default value (maybe because the definition of the view is Fallback-protected due to dbc tables always being Fallback).