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.

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.

ben on 10/9/2008

very clear!

Kiran on 1/21/2009

It's really very good thanks...........