Display table 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'

Display table in sql

SELECT * FROM TABLE_NAME;

Sql show tables

Showing all table: 
show tables;

Showing table data:
SELECT
* or column_names
FROM
table_name;

Return columns from table sql

SELECT *
FROM INFORMATION_SCHEMA.COLUMNS -- INFORMATION_SCHEMA is an ANSI-standard (American National Standard Institute) set of read-only views which provide information about all of the tables, views, columns, and procedures in a database
WHERE TABLE_NAME = N'Customers' -- "N" defines the subsequent string (the string after the N) as being in unicode

Source: stackoverflow.com

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

4 votes128 views1 answer
Mysql set max connections
SQL
-1 vote143 views1 answer
Default username and password for oracle 11g
SQL
0 vote141 views1 answer
Ms sql filter all sympbol
SQL
0 vote127 views1 answer
Mysql select last 15 minutes
SQL
0 vote162 views1 answer
Node-pre-gyp ERR! Tried to download(403): https://mapbox-node-binary.s3.amazonaws.com/sqlite3/v3.1.13/node-v72-win32-x64.tar.gz
SQL
11 votes141 views1 answer
Creating tables in sql with python
SQL
6 votes140 views3 answers
Mysql create database utf8
SQL
0 vote133 views1 answer
Sql server set complex constraints
SQL
0 vote188 views1 answer
Sql server system messeges
SQL
0 vote131 views1 answer
Exec procedure oracle
SQL