filmov
tv
List all tables in a sql server database using a query || Fetch all tables from a database in sql
Показать описание
In this video we will discuss, writing a transact sql query to list all the tables in a sql server database. This is a very common sql server interview question.
Object explorer with in sql server management studio can be used to get the list of tables in a specific database. However, if we have to write a query to achieve the same, there are 3 system views that we can use.
1. SYSOBJECTS - Supported in SQL Server version 2000, 2005 & 2008
2. SYS.TABLES - Supported in SQL Server version 2005 & 2008
3. INFORMATION_SCHEMA.TABLES - Supported in SQL Server version 2005 & 2008
-- Gets the list of tables only
Select * from SYSOBJECTS where XTYPE='U'
-- Gets the list of tables only
Select * from SYS.TABLES
-- Gets the list of tables and views
select * from INFORMATION_SCHEMA.TABLES
To get the list of different object types (XTYPE) in a database
Select Distinct XTYPE from SYSOBJECTS
Executing the above query on my SAMPLE database returned the following values for XTYPE column from SYSOBJECTS
IT - Internal table
P - Stored procedure
PK - PRIMARY KEY constraint
S - System table
SQ - Service queue
U - User table
V - View
Object explorer with in sql server management studio can be used to get the list of tables in a specific database. However, if we have to write a query to achieve the same, there are 3 system views that we can use.
1. SYSOBJECTS - Supported in SQL Server version 2000, 2005 & 2008
2. SYS.TABLES - Supported in SQL Server version 2005 & 2008
3. INFORMATION_SCHEMA.TABLES - Supported in SQL Server version 2005 & 2008
-- Gets the list of tables only
Select * from SYSOBJECTS where XTYPE='U'
-- Gets the list of tables only
Select * from SYS.TABLES
-- Gets the list of tables and views
select * from INFORMATION_SCHEMA.TABLES
To get the list of different object types (XTYPE) in a database
Select Distinct XTYPE from SYSOBJECTS
Executing the above query on my SAMPLE database returned the following values for XTYPE column from SYSOBJECTS
IT - Internal table
P - Stored procedure
PK - PRIMARY KEY constraint
S - System table
SQ - Service queue
U - User table
V - View
0:05:38
List all tables in a sql server database using a query Part 65
0:05:04
How to list all tables in an Oracle Database
0:03:34
List all tables in a sql server database using a query || Fetch all tables from a database in sql
0:00:23
SQL Tips | How to Find All Tables containing a Column? #sqltips
0:03:56
Show All Tables in Database
0:00:32
sql query to view all tables from database (oracle).
0:03:39
How to List All Tables in MySQL Database
0:00:47
how to see all tables in Oracle SQL | User Tables
0:21:18
How to Determine the Date of the Second Last Order Placed by a Customer in Microsoft Access (DMax)
0:10:17
SAP Tables - Finding tables associated with Tcodes
0:05:18
Search All Fields in all tables for a specific value in Oracle
0:02:31
9 - SQL - Show Tables of a Database
0:02:58
How to make table captions and a list of tables in word
0:05:49
Retrieving a list of SQL Server objects (constraints, tables, views, functions) using sys.objects
0:07:55
Find all Tables that contain a specific Column name in SQL Server Database
0:01:52
Display List schemas in SQL Server database
0:01:10
#10 Show Tables Command in SQL | SQL Tutorial
0:08:42
Minecraft Ultimate Every Workbench Guide
0:05:09
Get all table names and column names of database in SQL Server database
0:06:02
List Workbook Tables And References
0:01:53
QuickTips #7 | How to find all tables containing a particular field in SAP | AC SAP Consulting
0:11:12
Easily Compare Multiple Tables in Power Query
0:09:42
Automatically Generate List of Tables in Microsoft Office Word
0:00:38
How to get COLUMN NAMES in SQL
Комментарии