/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

0 vote226 views1 answer
Safe mysql
SQL
2 votes242 views3 answers
Sql interview query questions
SQL
3 votes219 views1 answer
Sql several or
SQL
0 vote233 views1 answer
How to get table current identity value in sql server
SQL
4 votes218 views2 answers
Tables in sql
SQL
0 vote232 views1 answer
Sql last 3 rows
SQL
-2 votes240 views2 answers
Union vs union all in sql
SQL
0 vote224 views2 answers
Mysql output csv
SQL
0 vote188 views1 answer
Mysql find foreign key references
SQL
1 vote219 views2 answers
Sqlalchemy.exc.OperationalError: (sqlite3.OperationalError) unable to open database file
SQL

Share