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 vote234 views1 answer
Power bi union columns
SQL
1 vote246 views1 answer
Oracle grant select on schema
SQL
0 vote233 views1 answer
How to check the port of mysql installation in mac
SQL
0 vote237 views1 answer
Mysql select field if condition
SQL
11 votes250 views3 answers
How to get last row of table in sql
SQL
0 vote242 views1 answer
Create table sql generator
SQL
0 vote283 views1 answer
How to use mysql_tzinfo_to_sql on windows
SQL
3 votes240 views3 answers
Create a view postgres
SQL
0 vote228 views1 answer
Mysqldump don't drop table
SQL
0 vote186 views1 answer
Sqlalchemy existing database
SQL