/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

3 votes300 views1 answer
Sql multi column index performance
SQL
20 votes335 views1 answer
Get all table name in sql through php
SQL
0 vote276 views1 answer
Sql random decimal
SQL
13 votes301 views6 answers
Current date sql
SQL
0 vote293 views1 answer
Deny select insert update delete sql
SQL
16 votes320 views6 answers
Install sqlite3 python
SQL
0 vote289 views1 answer
Increment id in mysql
SQL
11 votes313 views2 answers
Insert date sql
SQL
2 votes304 views1 answer
Mysql how to store lat,lng
SQL
1 vote317 views1 answer
Ubuntu mysql cannot connect to database server remote
SQL

Share