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

3 votes191 views3 answers
Create table in SQL Server
SQL
3 votes146 views2 answers
Oracle sql truncate table
SQL
0 vote150 views1 answer
Restore backupfile discourse
SQL
0 vote153 views1 answer
Start and stop mysql
SQL
0 vote166 views2 answers
Oracle create tablespace autoextend
SQL
2 votes154 views2 answers
Mysql get time from datetime
SQL
0 vote142 views1 answer
Oracle 11g forget password
SQL
1 vote180 views1 answer
Oracle plan hash value
SQL
2 votes148 views1 answer
Sql create database
SQL
3 votes148 views2 answers
Postgresql remove not null constraint
SQL