sp_msforeachtable
Example/Syntax - Needs to be run at the context of the Database.
The below will do a row count on all your tables in a Database:
Output would look something like:
This blog is mostly a blog for me with hints to remember those little bits of code etc where ever I am. Please be aware of this when reading any of the posts as they are mainly reminders for me. When I get time I will try to flesh out those sections that are a little ambiguous.
No comments:
Post a Comment
Note: only a member of this blog may post a comment.