Sql show tables

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 table names in sql query

BY LOVE SINGHSELECT TABLE_NAME
FROM INFORMATION_SCHEMA.TABLES
WHERE TABLE_TYPE = 'BASE TABLE' AND TABLE_CATALOG='YOUR_Database_name'

Sql show tables

Showing all table: 
show tables;

Showing table data:
SELECT
* or column_names
FROM
table_name;

Mariadb show tables

SHOW TABLES FROM database

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

-1 vote179 views1 answer
How to create foreign key in sql server management studio
SQL
0 vote173 views1 answer
Enable sql server full text indexing
SQL
0 vote189 views3 answers
Constraint sql
SQL
2 votes165 views1 answer
Postgresql format date dd/mm/yyyy
SQL
3 votes180 views1 answer
Start mysql server linux terminal
SQL
2 votes169 views1 answer
Mysql create user with mysql_native_password
SQL
0 vote177 views1 answer
Error in connection_import_file(conn@ptr, name, value, sep, eol, skip) : RS_sqlite_import: test.csv line 2 expected 11 columns of data but found 1
SQL
0 vote167 views1 answer
Debian 10 install postgresql 2ndquadrant
SQL
3 votes210 views1 answer
Oracle nextval insert
SQL
1 vote180 views1 answer
Pl sql create table from another table
SQL