System tables

fn_servershareddrives

Deprecated feature

Replacement

Feature name

fn_servershareddrives

fn_get_sql

Deprecated feature

Replacement

Feature name

sysaltfiles

syscacheobjects

syscolumns

syscomments

sysconfigures

sysconstraints

syscurconfigs

sysdatabases

sysdepends

sysdevices

sysfilegroups

sysfiles

sysforeignkeys

sysfulltextcatalogs

sysindexes

sysindexkeys

syslockinfo

syslogins

sysmembers

sysmessages

sysobjects

sysoledbusers

sysopentapes

sysperfinfo

Compatibility views. For more information, see

System

Compatibility Views.

Important:

The compatibility views don’t expose metadata for

features that were introduced in SQL Server 2005 (9.x). We

recommend that you upgrade your applications to use

catalog views. For more information, see

System catalog

views.