/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

1 vote197 views1 answer
Select not matching data with join table
SQL
11 votes161 views4 answers
Update row in mysql
SQL
0 vote163 views1 answer
Describe in sqlite3
SQL
5 votes232 views1 answer
Oracle source query
SQL
1 vote158 views1 answer
Job for mariadb.service failed because the control process exited with error code. see "systemctl status mariadb.service" and "journalctl -xe" for details.
SQL
4 votes167 views2 answers
Bulk kill mysql processlist
SQL
0 vote152 views1 answer
Oracle current timestamp
SQL
1 vote156 views1 answer
Sometimes i cant edit sql developer
SQL
0 vote167 views1 answer
Top 3 salary in sql
SQL
0 vote156 views1 answer
Docker export psql sql
SQL

Share