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

6 votes273 views1 answer
Wordpress change user password sql
SQL
16 votes273 views4 answers
Find duplicates mysql
SQL
0 vote263 views1 answer
Sql database connectivity
SQL
3 votes284 views2 answers
Find string in stored procedure sql server
SQL
0 vote272 views1 answer
Incorrect datetime value sql table error 1292
SQL
0 vote281 views1 answer
Postgres populate table from another table
SQL
6 votes258 views4 answers
Sqlite drop table
SQL
0 vote341 views1 answer
Split first name and last name in sql
SQL
6 votes263 views4 answers
Eloquent to sql with bindings
SQL
0 vote242 views1 answer
Mysql workbench search all tables
SQL