/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

3 votes236 views2 answers
WhereIn SQL
SQL
0 vote165 views1 answer
Get last run query sql server
SQL
0 vote212 views1 answer
Postgres in operator with comma separated values
SQL
0 vote238 views1 answer
Show all sequences postgres
SQL
2 votes196 views1 answer
Postgresql add entry to table
SQL
0 vote260 views1 answer
000webhost database values insert
SQL
0 vote222 views1 answer
How to do a function to return row type from a table in pl/sql
SQL
0 vote226 views1 answer
Query to count the number of rows in a table in sqlalchemy
SQL
13 votes378 views4 answers
Sql joining 3 tables
SQL
1 vote218 views1 answer
Postgres convert date to string
SQL

Share