/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 vote185 views1 answer
Backup mysql data only
SQL
3 votes255 views2 answers
How to modify rows in SQL Server
SQL
0 vote176 views1 answer
Sql contains numeric characters
SQL
-2 votes200 views1 answer
Mysql see users and passwords
SQL
1 vote181 views1 answer
T-sql find object by name
SQL
3 votes194 views2 answers
SqlMessage: "Host '192.168.64.1' is not allowed to connect to this MariaDB server
SQL
8 votes185 views2 answers
Between operator
SQL
3 votes220 views1 answer
How to add unique constraint in mysql table
SQL
0 vote236 views1 answer
How to pass list as parameter in SQL query
SQL
4 votes215 views3 answers
Sqlite show columns
SQL

Share