System Tables mu SQL Server MDF uye NDF dhatabhesi

In SQL Server MDF uye NDF dhatabhesi, kune akawanda masisitimu matafura anoshandiswa kuchengetedza chimiro uye imwe meta dhata remadhata.

Pazasi pane runyorwa rweyakajairika-anoshandiswa system matafura

System Tafura Zita
sys.kugoverwa_units
sys. zvinhu
sys.assembly_modules
sys. maparamende
sys.check_constraints
sys. zvikamu
sys .columns
sys. maitiro
sys.computed_columns
sys. zvinotevera
sys.default_constraints
sys.service_queues
sys.events
sys.sql_dependency
sys.event_notifications
sys.sql_expression_dependency
sys.extended_procedures
sys.sql_modules
sys.foreign_key_columns
sys.stats
sys.foreign_keys
sys.stats_columns
sys.function_order_columns
sys.synonyms
sys.hash_indexes
sys.table_types
sys.identity_columns
sys.tables
sys.index_columns
sys.trigger_event_types
sys.indexes
sys.trigger_events
sys.key_constraints
sys.triggers
sys.nhamba- nzira_parameter
sys.kutarisa
sys.nhamba-maitiro

References:

  1. Chinhu Chinhu Catalog Maonero (Transact-SQL) ye SQL Server 2014
  2. Chinhu Chinhu Catalog Maonero (Transact-SQL) ye SQL Server 2012
  3. Chinhu Chinhu Catalog Maonero (Transact-SQL) ye SQL Server 2008 R2
  4. Chinhu Chinhu Catalog Maonero (Transact-SQL) ye SQL Server 2008
  5. Chinhu Chinhu Catalog Maonero (Transact-SQL) ye SQL Server 2005