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

0 vote165 views1 answer
Postgres add prefix to primary key
SQL
5 votes184 views2 answers
Oracle timestamp to date
SQL
17 votes185 views6 answers
Current date in sql
SQL
0 vote186 views1 answer
Mysql pad zeros
SQL
0 vote169 views2 answers
Sql query unique
SQL
7 votes186 views6 answers
Nth highest salary in sql
SQL
1 vote204 views1 answer
Write a query to create an empty table from an existing table?
SQL
0 vote180 views1 answer
VSCode SQL Server Connection error
SQL
0 vote156 views1 answer
Resolved [java.sql.SQLException: ORA-29977: Unsupported column type for query registration in guaranteed mode ]
SQL
8 votes205 views1 answer
Mysql dump restore
SQL