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

0 vote384 views1 answer
How to subquey to do not load in live database in
SQL
1 vote325 views2 answers
Grab part of a string sql
SQL
2 votes298 views1 answer
Sql server conection string
SQL
0 vote335 views1 answer
Select year from dual oracle
SQL
0 vote301 views3 answers
Sql count condition
SQL
0 vote317 views1 answer
What does leave do in mysql
SQL
16 votes312 views2 answers
Add column if not exists mysql
SQL
3 votes300 views3 answers
Create table in microsoft sql server
SQL
1 vote284 views1 answer
Oracle lowercase
SQL
1 vote296 views3 answers
Psql fatal database does not exist
SQL