SqlShare.com Logo
 
Skip Navigation Links
Home
Channels
Classes
About Us
Login / Register
Subscribe to the All channels feed  Goto the SqlShare.com blog
Image of Tim Mitchell
Author:

Author Bio:
Tim Mitchell is a Microsoft SQL Server database developer, business intelligence consultant, writer, and speaker. He has been working professionally with SQL Server for over six years, and holds the MCTS and MCDBA certifications from Microsoft as well as a Bachelor's degree in computer science from Texas A&M University - Commerce.
Using the Tables Collection in SMO

Using the Tables Collection in SMO

SQL SMO is a way to access almost every part of SQL Server using an object interface that's perfect for a programmer (or a DBA that can write a little code!). Tim Mitchell provides a short introduction to the Tables collection, which provides an easy way to iterate through all of the tables in a database. Note that he as many other SMO videos if you're just starting out, you may want to watch them all.

Video Information
Publish Date:
September 10, 2008
Length:
2:24
Skill Level:
200
Rating:
4.19 out of 5

After watching you should be able to answer these questions:
  1. The tables collection is a property of which object?

  2. To return the number of rows in a table, which of the following is the right way to do it using SQL SMO?
You must be logged in to view this video.    

Bookmark and Share

  Rate This Video:  
 
1=Poor, 3=Good, 5=Excellent
Comments:
ben on 10/9/2008
very clear!

Kiran on 1/21/2009
It's really very good thanks...........



Must Be Logged In

References
Download the code from this video

Sponsored Ads
 

How Do I Become a Video Author? |  Newsletter History

Copyright © Fourdeuce, Inc., 2005-2009. All Rights Reserved | Privacy Policy | Terms & Conditions