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 vote334 views1 answer
Supprimer les valeur d'une table mysql
SQL
0 vote374 views1 answer
SQLSTATE[42000]: Syntax error or access violation: 1140 Mixing of GROUP columns (MIN(),MAX(),COUNT(),...) with no GROUP columns is illegal if there is no GROUP BY clause
SQL
3 votes284 views1 answer
Mysql CURRENT_TIMESTAMP()
SQL
0 vote396 views1 answer
How to check common records in 2 table
SQL
0 vote310 views1 answer
Mysql workbench indent formatting
SQL
0 vote310 views1 answer
"SET SQL_AUTO_IS_NULL = 0" query problem
SQL
1 vote314 views2 answers
How to enable error squiggles in vs code
SQL
0 vote336 views1 answer
Shows all databases created by user in ms sql
SQL
1 vote301 views1 answer
How refresh navicat tables to see new tables
SQL
1 vote330 views1 answer
Mysql datetime with timezone offset
SQL