/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 vote169 views1 answer
Mssql check if date is greater than today
SQL
6 votes161 views2 answers
Find mysql version linux
SQL
2 votes163 views2 answers
Sqlalchemy filter or
SQL
0 vote168 views1 answer
Mysql shell ERROR: Not connected.
SQL
0 vote161 views1 answer
Call to undefined function mysql_query() in D:\xampp\htdocs\image\index.php:11 Stack trace: #0 {main} thrown in site:stackoverflow.com
SQL
0 vote173 views1 answer
Apex for oracle 11g
SQL
2 votes114 views1 answer
Sql view column data type
SQL
0 vote171 views1 answer
Oracle service name view
SQL
1 vote178 views1 answer
Quit mysql
SQL
0 vote158 views1 answer
Sql server manager close connection
SQL

Share