Ways to find all tables in sql server Final
A database object is any defined object in a database that is used to store or reference data.
Anything which we make from create command is known as Database Object.
It can be used to hold and manipulate the data.
Some of the examples of database objects are : view, sequence, indexes, etc.
1. The simplest way to get all tables in a specific database it’s to see their list in SQL Server Management Studio (SSMS) Object explorer.
2. Information_schema -- For all tables
3. sys.tables
4. sys.objects
5. SELECT * FROM sys.all_objects where type='u'
6. select * from sysobjects where xtype='U'-- for User defined tables
7. exec sp_msforeachtable 'print ''?'''
