title: How to show database tables if it is hidden in SQL Server 2008
body: <p>In my remote server some system configuration problem system harddisk was changed.So in SQL Server all data was deleted, used xx database which has no tables but using query (select * from information.schema.tables) it displaying base tables only.How to show them?</p>
  
  <p><img src="https://i.stack.imgur.com/p8sB0.png" alt="SSMS"></p>