Teh INFORMATION_SCHEMA views are new to SQL2000. Don't get too comfortable querying the system tables directly. Microsoft keeps threatening to change the structure of them without notice. However, they have also said that the INFORMATION_SCHEMA views will not change.
I am indeed in Tampa Bay (St Petersburg) - one of the few Florida natives remaining in the state. I can't move up north. Anything below 70 degrees is cold to me. LOL
--Angel
-----------------------------------
Behold! As a wild ass in the desert
go forth I to do my work.
--Gurnie Hallock (Dune)
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.