Oct 11, 2006 #1 jimberger Programmer Jul 5, 2001 222 GB Hello, IS there a query or system stored procedure that will return all the user tables in the database? Thanks Jimmmy
Hello, IS there a query or system stored procedure that will return all the user tables in the database? Thanks Jimmmy
Oct 11, 2006 #2 SQLDenis Programmer Oct 1, 2005 5,575 US select table_name,* from information_schema.tables where table_type ='BASE TABLE' Denis The SQL Menace SQL blog:http://sqlservercode.blogspot.com/ Personal Blog:http://otherthingsnow.blogspot.com/ Upvote 0 Downvote
select table_name,* from information_schema.tables where table_type ='BASE TABLE' Denis The SQL Menace SQL blog:http://sqlservercode.blogspot.com/ Personal Blog:http://otherthingsnow.blogspot.com/