/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 votes106 views5 answers
Tablespace ORACLE
SQL
0 vote114 views1 answer
PGSQL dynamic table name
SQL
0 vote111 views1 answer
Convert multiple columns to ROws in sql server
SQL
0 vote103 views1 answer
Backup and restore of sqlite database from c# -sqlserver
SQL
1 vote104 views1 answer
ORA-01950
SQL
0 vote119 views1 answer
Python sqlalchemy connection show server
SQL
1 vote108 views1 answer
Temp table vs variable table in sql server
SQL
-1 vote150 views1 answer
Difference berween database and data base management system
SQL
6 votes98 views1 answer
Oracle trigger after connect
SQL
1 vote101 views1 answer
How to drop function in sql
SQL

Share