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

2 votes200 views1 answer
Coalesce sql
SQL
0 vote159 views1 answer
Mysql group rows with same value
SQL
0 vote162 views1 answer
Sql server: how to assign value to table variable returned from function
SQL
7 votes202 views1 answer
Sql disable safe mode
SQL
0 vote210 views1 answer
Postgresql alter table sequence
SQL
1 vote192 views1 answer
Oracle select row max date
SQL
2 votes164 views1 answer
SELECT INTO
SQL
1 vote156 views1 answer
Error code 1175 mysql fix
SQL
0 vote182 views1 answer
Is not numeric sql
SQL
16 votes190 views3 answers
MySQL 8.0 - Client does not support authentication protocol requested by server; consider upgrading MySQL client
SQL