That is a good script but with a little problem. It shows 1 less table than in the schema. Its not a script from me so I have not changed the contributor's name.
The only change is I have made is moved FETCH NEXT statement at the end of the loop and removed IF @@FETCH_STATUS = 0 statement. Correct me if I am wrong
Well i found it when customizing for a single table.
Methods for Parsing XML files
Jon shows you several ways you can parse XML.
2007-10-02 (first published: 2002-06-20)