THE SQL Server Blog Spot on the Web

Welcome to SQLblog.com - The SQL Server blog spot on the web Sign in | |
in Search

Browse by Tags

All Tags » metadata » INFORMATION_SCHEMA   (RSS)
  • T-SQL Tuesday #24 : Dude, where's the rest of my procedure?

    This month's T-SQL Tuesday is being hosted by Brad Schulz (blog) and the topic is one that should attract a lot of submissions: Procedures and Functions. Last week, I talked about the case against INFORMATION_SCHEMA views - I provided several examples where I feel the INFORMATION_SCHEMA views fall short of the catalog views, and expressed my ...
    Posted to Aaron Bertrand (Weblog) by AaronBertrand on November 8, 2011
  • The case against INFORMATION_SCHEMA views

    In SQL Server 2000, INFORMATION_SCHEMA was the way I derived all of my metadata information - table names, procedure names, column names and data types, relationships... the list goes on and on. I used the system tables like sysindexes from time to time, but I tried to stay away from them when I could. In SQL Server 2005, this all changed with ...
    Posted to Aaron Bertrand (Weblog) by AaronBertrand on November 3, 2011
Powered by Community Server (Commercial Edition), by Telligent Systems
  Privacy Statement