Can we create views only on column table only ?

[pavneet_rana]

Hi to all,

Small doubt,

Can we create views only on column table only ?

or

Can we can not create view on row base table.

if its so, then why ?

Regards

Pavneet Rana

[lbreddemann · Accepted solution]

Hmm... your two-part question includes a logical overlapping negation.

Are you yourself actually sure about what you want to know?

Just taking the keywords of your question "column table", "row base table", "create view" I can come up with a statement like this:

"In SAP HANA you can create SQL views on any kind of table. Columnviews on the other hand (that is Analytic Views, Attribute Views and Calculation Views) can only be created on column store tables".

All this is of course documented...

- Lars