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

2 votes443 views2 answers
Python escape string for sql
SQL
-1 vote400 views4 answers
Full outer join in sql
SQL
0 vote336 views1 answer
Sqlserver now
SQL
3 votes340 views4 answers
Show columns from table
SQL
1 vote355 views1 answer
How to change owner in postgres
SQL
0 vote357 views2 answers
How to delete the rows with null values in mysql
SQL
4 votes358 views4 answers
Pl sql output
SQL
-1 vote351 views1 answer
Capitole toulouse
SQL
0 vote333 views1 answer
TITLE: SQL Server principal "dbo" does not exist
SQL
2 votes353 views1 answer
How to insert string variable into sqlite database
SQL