I want to hide tables in SQL Server database

Question

I've created a data sync process in Azure so that Azure has created few tables in my SQL Server database in the Datasync schema. I want to hide those tables that are located in the Datasync schema.

Can you guys please suggest how to avoid showing those tables in Azure, or how to hide tables from my SQL Server?

Answer 1

There is No HIDE feature in SQL Server instead, you can Deny the permission to that Table for Certain Users of User Groups whom you do not want to view the Tables or Objects on your schema

You can Use the DENY keyword to deny certain Users and REVOKE to Remove the existing permission