/SQL/Show tables sql server

Show tables sql server

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'

13

Show tables sql server

USE YOUR_DATABASE_NAME
SELECT *
FROM INFORMATION_SCHEMA.TABLES

2

Sql show tables

Showing all table: 
show tables;

Showing table data:
SELECT
* or column_names
FROM
table_name;

2

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'

0

Similar codes

5 votes128 views2 answers
Oracle rename table
SQL
4 votes114 views2 answers
Dbms_scheduler stop job
SQL
0 vote110 views1 answer
Sqlite closes value
SQL
1 vote120 views2 answers
Replace text in sql
SQL
1 vote118 views1 answer
Mysql remove last empty newline
SQL
0 vote210 views1 answer
Running mysql from bash sc
SQL
4 votes121 views2 answers
Sqlalchemy_database_uri for mysql
SQL
0 vote135 views1 answer
Update database collation in postgresql
SQL
0 vote113 views1 answer
Datagrip exec
SQL
0 vote120 views1 answer
Recursive query herarchical data sql server
SQL

Share