/SQL/Get tables in database sql

Get tables in database sql

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

Get tables in database sql

SELECT
  *
FROM
  INFORMATION_SCHEMA.TABLES;

0

Similar codes

2 votes206 views2 answers
Mysql get time from datetime
SQL
0 vote215 views1 answer
Sql counter column
SQL
0 vote223 views1 answer
How to login to mysql in homestead
SQL
0 vote263 views1 answer
Sparql list all graphs
SQL
0 vote208 views1 answer
Mysql money value
SQL
17 votes285 views4 answers
Show all tables in oracle
SQL
0 vote215 views1 answer
Error: connect ECONNREFUSED 127.0.0.1:5432 at TCPConnectWrap.afterConnect [as oncomplete] (net.js:1148:16
SQL
0 vote223 views1 answer
Mysql date format unix timestamp
SQL
4 votes218 views1 answer
Oracle session date format
SQL
0 vote223 views1 answer
Alter database name script
SQL

Share