Friday, June 4, 2010

SQL Server 2008 System Functions to Research Tables, Views, Indexes, Columns, Stored Procedures, etc.

SQL Server provides several system meta data functions to get property values for different object types. Each system meta data function has a set of properties you can query using the system meta data function. In this article, I am going to outline examples on the following functions, for details click here.

  • OBJECTPROPERTY and OBJECTPROPERTYEX
  • INDEXPROPERTY
  • COLUMNPROPERTY

No comments:

Post a Comment