/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 vote339 views2 answers
Update query with between in mysql
SQL
0 vote337 views1 answer
How to check the port of mysql installation in mac
SQL
0 vote356 views1 answer
Mysql failed to login as root@localhost
SQL
0 vote330 views1 answer
Mysql count grouped rows
SQL
0 vote351 views1 answer
How to check which table has data in mysql
SQL
1 vote379 views1 answer
Postgres see sequence current state
SQL
3 votes361 views1 answer
Sql case update
SQL
3 votes285 views2 answers
Mysql sum with condition
SQL
4 votes315 views2 answers
Oracle set date format
SQL
1 vote339 views1 answer
Where to locate set password for mysql
SQL

Share