Hide/Show Tables from Object Explorer

Just thought of sharing an information about how to hide/show tables from your object explorer. The below query has to cut and paste in your query and “CNTRL+SHIFT+M” to input your parameters. One more thing… CNTRL+SHIFT+M work like a programming language giving us an opportunity to input the parameter in query analyser.

--To Hide the object

EXEC sp_addextendedproperty 

@name = N'microsoft_database_tools_support', 

@value = '<Hide , 1 Or 0, ?>', 

@level0type ='schema', 

@level0name ='<Schema Name, sysname, dbo>',

@level1type = 'table', 

@level1name = N'<Table Name, sysname, ?>'

--To Show the object

EXEC sp_dropextendedproperty 

@name = N'microsoft_database_tools_support', 

@level0type ='schema', 

@level0name ='<Schema Name, sysname, dbo>',

@level1type = 'table', 

@level1name = N'<Table Name, sysname, ?>'