Navigation¶

• Main Page
  

• Random Page
• Create a new Page
• All Pages
• Categories
  

• Administration
• File Management
  

• Login/Logout
• Language Selection
• Your Profile
• Create Account
  

Quick Search
»
Advanced Search »

Catalog Views (sys.* views)

MSDN Link

sys.database_files¶

=====sys.databases===== Contains all the values for the DATABASEPROPERTY/DATABASEPROPERTYEX functions.

sys.check_constraints¶

=====sys.columns=====

sys.computed_columns¶

=====sys.foreign_keys=====

sys.foreign_key_columns¶

=====sys.identity_columns=====

sys.indexes¶

=====sys.index_columns=====

sys.key_constraints¶

=====sys.objects=====

sys.partitions¶

=====sys.procedures=====

sys.stats¶

=====sys.stats_columns=====

sys.synonyms ¶

=====sys.tables=====

sys.views¶

=====sys.triggers=====

sys.schemas¶

SECURITY¶

sys.server_principals¶

=====sys.server_permissions=====

sys.server_role_members¶

sys.database_principals¶

=====sys.database_permissions=====

sys.database_role_members¶

=====sys.master_key_passwords=====

sys.sql_logins¶