How to get all tables in sql

Get the list of all tables in sql server

SELECT TABLE_NAME
FROM INFORMATION_SCHEMA.TABLES
WHERE TABLE_TYPE = 'BASE TABLE' AND TABLE_CATALOG='YOUR_Database_name'

How to get all tables in sql

SELECT * FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_TYPE='BASE TABLE'

Sql query to list all tables in a database sql server

BY LOVE SINGH on May 19 2020SELECT TABLE_NAME
FROM INFORMATION_SCHEMA.TABLES
WHERE TABLE_TYPE = 'BASE TABLE' AND TABLE_CATALOG='YOUR_Database_name'

How to check table name in current database sql

SELECT TABLE_NAME
FROM INFORMATION_SCHEMA.TABLES
WHERE TABLE_TYPE = 'BASE TABLE' AND TABLE_CATALOG=db_name() 
and TABLE_NAME like'%table_name%'--to check particular table

Similar codes

1 vote368 views1 answer
Sql headers delphi
SQL
2 votes319 views1 answer
Mysql list users on ubuntu
SQL
0 vote370 views1 answer
Oracle sql all days except weekends
SQL
0 vote393 views1 answer
For row in sql database python loop
SQL
0 vote366 views1 answer
SQL SERVER xquery count child nodes
SQL
0 vote356 views3 answers
Sql drop all tables
SQL
0 vote369 views1 answer
Stored procedures example
SQL
21 votes351 views1 answer
Cheatsheet for sql
SQL
0 vote377 views1 answer
.sql File Run in PSQL
SQL
0 vote355 views1 answer
Mysql range of dates overlap
SQL