[SQL] Some of my favorite INFORMATION_SCHEMA utility queries
Posted by: JonGalloway.ToString(),
on 07 Jul 2006 |
View original | Bookmarked: 0 time(s)
Phil just
posted about using INFORMATION_SCHEMA to bulletproof your SQL change
scripts. I've been working up a post on using queries against
INFORMATION_SCHEMA views to generate SQL scripts, so this seems like a good
time to chime in. The
INFORMATION_SCHEMA views are views which describe a database's objects and
schema. Phil did a great job of explaining what the INFORMATION_SCHEMA
views are, so go take a look at his post if you'd like to know more. As the
title of his post...