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 vote128 views1 answer
Opensuse restart MySQL
SQL
1 vote134 views2 answers
Duplicate key value violates unique constraint "django_admin_log_pkey"
SQL
0 vote114 views2 answers
The metadata storage is not up to date, please run the sync-metadata-storage command to fix this issue.
SQL
0 vote115 views1 answer
Run mssql server terminal
SQL
3 votes126 views2 answers
MySQL query to get column names
SQL
6 votes167 views2 answers
How to get last element sql
SQL
0 vote116 views1 answer
Postgresql update to unique
SQL
15 votes126 views3 answers
Mysql update add to existing value
SQL
0 vote129 views1 answer
How to create notes in mysql
SQL
11 votes116 views2 answers
Safe mode off mysql
SQL