/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 vote193 views1 answer
Drop column from local database postgres pgadmin
SQL
7 votes182 views3 answers
How ot change name of column mysql
SQL
0 vote210 views2 answers
Starts and end with vowel sql
SQL
0 vote225 views1 answer
Sql tablo hangi sp de
SQL
0 vote266 views1 answer
Doctors appointment
SQL
0 vote196 views1 answer
Sql change default collation to utf8
SQL
7 votes223 views1 answer
Mysql unsafe update
SQL
0 vote211 views1 answer
SQLServerException.makeFromDatabaseError
SQL
0 vote159 views1 answer
Import sql file in mysql linux
SQL
0 vote199 views1 answer
Drop database using terminal postgres
SQL

Share