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

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:

The tables collection is a property of which object?

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.

Rate This Video:	12345
	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

Code from video

Download the code from this video