Nov 27, 2012

List All the Tables Using Sp Commands

11/27/2012 10:24:00 PM



List All the Tables for All Databases Using System Tables


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

Written by

We are Creative Blogger Theme Wavers which provides user friendly, effective and easy to use themes. Each support has free and providing HD support screen casting.

0 comments:

Post a Comment

Recent Posts
Popular Articles

 

© 2013 MUNISH ORACLE DBA& .Net Developer. All rights resevered. Designed by Templateism

Back To Top