List All the Tables from All the Databases ?

Posted by Syedshakeer under Sql Server category on | Views : 2203
Use the following script which list all the tables from all the database.
copy and paste the below script in Sql Query Analyzer and run it

sp_msforeachdb 'select "?" AS db, * from [?].sys.tables'

Comments or Responses

Login to post response