How to get list of all tables in database using T-SQL in SQL Server 2022

Channel:

java frm

Subscribers:

5,740

Published on December 27, 2022 8:18:41 PM ● Video Link: https://www.youtube.com/watch?v=FEZFHfaaR3U

Category:

Tutorial

Duration: 2:58

20 views

0

In this video we are going to see How to get list of all tables in database using T-SQL in SQL Server 2022

examples:

SELECT * FROM INFORMATION_SCHEMA.TABLES;

SELECT table_name FROM INFORMATION_SCHEMA.TABLES WHERE table_type = 'BASE TABLE'

SELECT name FROM sys.tables

SELECT name FROM sysobjects WHERE xtype = 'U'

SELECT name FROM sys.objects WHERE type_desc = 'USER_TABLE'