Its very simple to find all the table or view in a sql db. On management studio select your db and open a new query.
Then past this query
Select * from information_schema.tables
If you want to see only table add
Where table_type =’base table’
Its very simple to find all the table or view in a sql db. On management studio select your db and open a new query.
Then past this query
Select * from information_schema.tables
If you want to see only table add
Where table_type =’base table’
