
Get All Tables and Views Inside a Database
A nifty little trick is to be able to list all the Tables or Views, or even both, present in a database. A quick way to get All the Tables and Views follows: SELECT * FROM information_schema.tablesWHERE Table_schema = ‘dbo’ORDER BY Table_name In the above query, I retrieved all table-like