To get a list of tables, columns, etc. More stable than sysobjects, syscolumns, etc which might change.
If you wanted to update all columns named "MyID" with a default, you could write a loop that pulls from the columns view to know which tables might need ot be updated.
Steve Jones
sjones@sqlservercentral.com
http://www.sqlservercentral.com/columnists/sjones