/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 vote206 views1 answer
What is logical database schema
SQL
0 vote200 views1 answer
How to see password mysql vestacp
SQL
0 vote209 views1 answer
Test sql query
SQL
0 vote190 views1 answer
Mysql xampp reset root password
SQL
0 vote218 views1 answer
SQL Server date literal
SQL
4 votes204 views1 answer
SQL find text in SP
SQL
1 vote205 views1 answer
Order by oracle
SQL
22 votes216 views3 answers
SQL CHEATSHEET
SQL
0 vote216 views1 answer
Savepoint mysql script
SQL
0 vote203 views1 answer
Database xml sql
SQL

Share