How to find list of all user defined tables using SQL Server

Question

Anupam Mishra · Answer

Hi Simond,If you want toand and retrieve a list of all user defined tables in MS SQL SERVER then you write the following queries:SELECT * FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_TYPE = 'BASE TABLE'

forum

How to find list of all user defined tables using SQL Server

Simond Gear

Can you answer this question?

1 Answers

Liked By