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 vote284 views1 answer
Knex last insert id mysql
SQL
3 votes298 views2 answers
Find string in stored procedure sql server
SQL
2 votes316 views3 answers
Mysql kill
SQL
0 vote301 views1 answer
Oracle list user locked
SQL
0 vote270 views1 answer
Mysql export data with a where clause
SQL
0 vote276 views1 answer
Turnicate in mysql
SQL
4 votes283 views2 answers
Bulk kill mysql processlist
SQL
1 vote296 views1 answer
Regular expression in sql server
SQL
0 vote306 views1 answer
How to take sum of column with same id in "JPQL?"
SQL
-1 vote297 views2 answers
Create temporary table sql
SQL