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 vote402 views1 answer
How to find all children of a record with only parent ID in sql
SQL
0 vote361 views1 answer
Output to file mysql
SQL
0 vote391 views1 answer
Oracle last connexion
SQL
0 vote408 views1 answer
Mysql get first 2 characters of string
SQL
5 votes381 views1 answer
How to get all table names in sql query
SQL
4 votes392 views1 answer
Sql select limit range
SQL
2 votes331 views2 answers
Function in sql
SQL
4 votes370 views4 answers
Rollback in sql
SQL
0 vote395 views1 answer
Sql script to remove default from column
SQL
0 vote394 views1 answer
Select year from dual oracle
SQL