A database administrator has various tasks and responsibilities. Managing and keeping track of the database is one of them. Whether you are new or an experienced database administrator, you must know how to get the list of tables because of following reasons
It helps to understand the table structure and content of table. If you are familiar with the table structure, you can create desired and required indexes on it.
In SQL Server, we can get the list of tables by using any of the following methods:
Querying information_schema.tables. Querying system catalog view like sys.tables and sys.objects.