I always wanted to hide a table which is critical to be displayed to the end user who might be using management studio for some purpose. recently i came a across a property indeed an extended property introduced in sql server 2005 called sp_addextendedproperty. i found it interesting. so, i have searched books online (bol) for the usage and i found that i could hide the table from this procedure. i am posting the procedure to do this.
suppose you have a database mycompany schema users in which you have a table with important information containing telephone numbers, address and many more details table emp_details. you could hide the table from viewing in management studio with the help of sp_extendedproperty.
@name = N'microsoft_database_tools_support',
@value = '<Hide? , sysname, 1>',
@level0name ='users', --give the schema name here. if it is dbo give 'dbo'
@level1type = 'table',
@level1name = 'emp_details' --give the table name which you want to hide.
hope you enjoyed it....