# Hide or invisible column

**URL:** <https://www.singlestore.com/forum/t/hide-or-invisible-column/6418>\
**Category:** MemSQL Ops\
**Created:** [January 17, 2023, 1:41pm UTC](https://www.singlestore.com/forum/t/hide-or-invisible-column/6418 "2023-01-17T13:41:29Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![prathap\_26](https://www.singlestore.com/forum/letter_avatar_proxy/v4/letter/p/94ad74/32.png) [@prathap\_26](https://www.singlestore.com/forum/u/prathap_26)\
**Post date:** [January 17, 2023, 1:41pm UTC](https://www.singlestore.com/forum/t/hide-or-invisible-column/6418/1 "2023-01-17T13:41:29Z")

</div>

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

---

<div class="post-metadata">

**Author:** ![deyler](https://www.singlestore.com/forum/letter_avatar_proxy/v4/letter/d/3ab097/32.png) [@deyler](https://www.singlestore.com/forum/u/deyler)\
**Post date:** [January 18, 2023, 2:30am UTC](https://www.singlestore.com/forum/t/hide-or-invisible-column/6418/2 "2023-01-18T02:30:36Z")

</div>

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

---

<div class="post-metadata">

**Author:** ![prathap\_26](https://www.singlestore.com/forum/letter_avatar_proxy/v4/letter/p/94ad74/32.png) [@prathap\_26](https://www.singlestore.com/forum/u/prathap_26)\
**Post date:** [January 30, 2023, 4:40am UTC](https://www.singlestore.com/forum/t/hide-or-invisible-column/6418/3 "2023-01-30T04:40:54Z")

</div>

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

With regards,  
Prathap Reddy G

---

<div class="post-metadata">

**Author:** ![michael.arthur](https://www.singlestore.com/forum/user_avatar/www.singlestore.com/michael.arthur/32/1452_2.png) [@michael.arthur](https://www.singlestore.com/forum/u/michael.arthur)\
**Post date:** [August 5, 2023, 1:30am UTC](https://www.singlestore.com/forum/t/hide-or-invisible-column/6418/4 "2023-08-05T01:30:12Z")

</div>

Instead of hiding / making it invisible, could you instead mask the data?

For example, encrypt the data when inserting into the column and then have a UDF or an external function that will decrypt the data when retrieving it? Or simply encrypt it on insertion, return the encrypted value and leave decryption to the application layer?

---

<div class="post-metadata">

**Author:** ![michael.arthur](https://www.singlestore.com/forum/user_avatar/www.singlestore.com/michael.arthur/32/1452_2.png) [@michael.arthur](https://www.singlestore.com/forum/u/michael.arthur)\
**Post date:** [August 5, 2023, 2:12am UTC](https://www.singlestore.com/forum/t/hide-or-invisible-column/6418/5 "2023-08-05T02:12:23Z")

</div>

Also, if you don’t care about the decrypted value, but only that the value remains unique, you can hash it on insert. SSN 123-45-7890 always hashing to ABC-DE-FGHI might be good enough in a test environment if it’s being used as a key and just needs to be consistent with the other supporting records associated with that key.
