All Databases and All Tables

• Select All Databases from a Server (this is a system stored procedure)
  

sp_databases

• Select All Tables from a Particular Database
  

select name from sysobjects WHERE type = 'U'

106 unique visitors