/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 vote303 views1 answer
Rows to comma separated values in mssql
SQL
20 votes324 views1 answer
Get all table name in sql through php
SQL
8 votes278 views1 answer
Oracle find text in functions
SQL
-1 vote259 views1 answer
Mysql if example
SQL
8 votes349 views2 answers
Default sql server port
SQL
5 votes278 views4 answers
Describe table postgres
SQL
0 vote313 views1 answer
How to take sum of column with same id in "JPQL?"
SQL
0 vote251 views1 answer
How to set field to null in sql
SQL
0 vote297 views1 answer
Get create sql of hibernqte entity
SQL
10 votes310 views3 answers
Sql select between two dates
SQL

Share