/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

2 votes256 views1 answer
Enum in SQL Server
SQL
0 vote297 views1 answer
Sql server phone constraint
SQL
5 votes267 views1 answer
Find table from column name in sql
SQL
0 vote256 views2 answers
Update all linkedserver tables with openquery on db
SQL
0 vote252 views1 answer
Dasebase_url-postgres for windows
SQL
1 vote262 views1 answer
How do you use sql in you company
SQL
0 vote284 views1 answer
Sqlite unique multiple columns
SQL
3 votes255 views1 answer
Oracle list invalid password ORA-01017
SQL
1 vote266 views1 answer
Deleting database in sql
SQL
1 vote226 views1 answer
Database run
SQL

Share