/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

5 votes126 views1 answer
Sql add column after another
SQL
0 vote188 views1 answer
How to get number of months between 2 dates sql server
SQL
0 vote206 views1 answer
"inspanel" intitle:"login" -"cannot" "Login ID" -site:luckyfish.io
SQL
0 vote120 views1 answer
How to move a columns location in mysql
SQL
0 vote151 views1 answer
Query to insert image
SQL
0 vote147 views1 answer
How to check database engine in mysql
SQL
1 vote119 views1 answer
How to select random rows from table
SQL
0 vote111 views1 answer
Insert thai language sql server
SQL
0 vote123 views1 answer
Suse status MySQL
SQL
0 vote124 views1 answer
What is the difference between the LIKE and REGEXP operators in mysql?
SQL

Share