/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 vote102 views1 answer
Case when with count and combining similar values in sql
SQL
0 vote109 views1 answer
Linked server delete openquery
SQL
13 votes103 views2 answers
Get date from now() mysql
SQL
2 votes120 views2 answers
Checking data type in sql server
SQL
5 votes119 views2 answers
To date oracle
SQL
-1 vote109 views4 answers
Restart mysql server ubuntu
SQL
0 vote117 views1 answer
Typical max-connect-errors mysql
SQL
0 vote106 views1 answer
Mysql command line top 10
SQL
1 vote100 views1 answer
Drop table if exists oracle
SQL
1 vote108 views1 answer
Sql try catch
SQL

Share