/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

7 votes196 views3 answers
Sql fill table with info from anothe rtable
SQL
0 vote193 views1 answer
Drop all tables db2
SQL
0 vote220 views1 answer
Sql field equals multiple values
SQL
1 vote153 views1 answer
Pagination sql
SQL
2 votes191 views1 answer
Drop table if exists in postgres
SQL
16 votes213 views2 answers
Oracle ddl
SQL
13 votes193 views5 answers
Oracle list tables
SQL
3 votes219 views5 answers
Foreign keys
SQL
6 votes186 views4 answers
Delete table sqlite
SQL
1 vote197 views1 answer
Mysql2::Error: Incorrect string value: '\xE2\x80\x8B
SQL

Share