TABLE 1: SQL Server Property Functions
Version Property Functions
SQL Server 7.0 COLUMNPROPERTY()
  DATABASEPROPERTY()
  FILEGROUPPROPERTY()
  FILEPROPERTY()
  INDEXPROPERTY()
  OBJECTPROPERTY()
  TYPEPROPERTY()
SQL Server 2000 INDEXKEY_PROPERTY()
  DATABASEPROPERTYEX()
  SERVERPROPERTY()
  SESSIONPROPERTY()
  SQL_VARIANT_PROPERTY()