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 vote196 views1 answer
Oracle exchange subpartition
SQL
0 vote194 views1 answer
Postgresql delete limit
SQL
0 vote202 views1 answer
Check if has alpha characters sql
SQL
0 vote229 views1 answer
Compress sql file database ubuntu
SQL
0 vote206 views1 answer
Sql drop default
SQL
0 vote158 views1 answer
Mysql insert with foreign key
SQL
0 vote199 views1 answer
Narural join
SQL
0 vote188 views1 answer
Flask sqlalchemy. commit does not save changes
SQL
0 vote204 views1 answer
Query params sql insert python f string
SQL
2 votes234 views1 answer
Sql server: select column values as comma separated string
SQL