/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

0 vote115 views1 answer
Raven ql select count
SQL
16 votes147 views3 answers
Delete row psql
SQL
0 vote224 views1 answer
Mysql update table from select on another table
SQL
-1 vote139 views1 answer
Add column alter table default value
SQL
7 votes153 views1 answer
Set sequence value oracle
SQL
0 vote153 views1 answer
Amount of entries in a table psql
SQL
0 vote158 views1 answer
Frename oracle
SQL
0 vote148 views1 answer
Gcloud check sql
SQL
0 vote159 views1 answer
Setval in postgres
SQL
0 vote155 views1 answer
Firebird where
SQL

Share