Sign up for the ITPro Today newsletter
Stay on top of the IT universe with commentary, news analysis, how-to's, and tips delivered to your inbox daily.
How can I list all user tables on an SQL Server?
Neil Pike
December 23, 1999
1 Min Read
A. The SQL Server specific way (all versions) is :-
select name from sysobjects where type = 'U'
The ANSI standard way (SQL 7 only) is :-
select TABLE_NAME from INFORMATION_SCHEMA.TABLES
About the Author
You May Also Like
.png?width=700&auto=webp&quality=80&disable=upscale)