Hide or invisible column

SingleStore Tools MemSQL Ops
#1

Hi Team,
We have the requirement to create table with one of the columns in HIDDEN/INVISIBLE state.
I am not able to create table by specifing HIDDEN/INVISIBLE.

CREATE TABLE T1)
ID INT,
FNAME VARCHAR(55),
SSN VARCHAR(11) HIDDEN/INVISIBLE
)

appreciate if I get a solution for it.

With regards,
Prathap Reddy G

#2

Hi Prathap,

We don’t support hidden/invisible columns. I would suggest creating a view on top of the table instead and skip the column(s) you want to hide in the view.

Hope this helps!

-Dave

#3

Hi Deyler,
View is not the right option for us. Thank you for your response.

With regards,
Prathap Reddy G