/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

5 votes337 views2 answers
Oracle show procedures
SQL
0 vote315 views1 answer
Jooq finding lastest value in table
SQL
0 vote355 views1 answer
Postgresql create query
SQL
0 vote383 views1 answer
Contraint default SQL
SQL
1 vote346 views1 answer
How to get mysql db size
SQL
0 vote357 views1 answer
Mysql exception output
SQL
4 votes298 views1 answer
And or sql order of operations
SQL
4 votes372 views1 answer
Data types in sql
SQL
9 votes382 views4 answers
Mysql set id auto increment
SQL
0 vote338 views2 answers
How to update the multiple rows in sql
SQL

Share