/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 vote136 views3 answers
Epoch to datetime
SQL
15 votes138 views4 answers
Create table if not exists sql
SQL
0 vote129 views1 answer
See the structure of a table mysql
SQL
23 votes138 views4 answers
How to uninstall postgresql in ubuntu
SQL
0 vote174 views1 answer
Display all node label neo4j
SQL
0 vote124 views1 answer
Incorrect string value: '\xC4\x81ne' for column
SQL
16 votes139 views3 answers
Update table from another table
SQL
0 vote127 views1 answer
Enable outgoing remote MySQL access
SQL
0 vote126 views1 answer
How to check if there is no database schema
SQL
0 vote141 views1 answer
Sql track modification
SQL

Share