Iitafile zenkqubo kwi SQL Server Idatha ye-MDF kunye ne-NDF

In SQL Server I-MDF kunye ne-NDF yolwazi, zininzi iitafile zenkqubo ezisetyenziselwa ukugcina ubume kunye nezinye iinkcukacha zeemeta zedatha.

Apha ngezantsi kukho uluhlu lweetafile zenkqubo ezisetyenziswa ngokufanayo:

Igama leTheyibhile yeNkqubo
sys.ulwabiwo_units
sys. izinto
sys.assembly_modules
iiparameter
sys.check_constraints
izahlulo
sys. iikholamu
iinkqubo
syc.computed_columns
emva koko
sys.default_constraints
sys.service_queues
iziganeko
sys.sql_okuxhomekeka
sy_event_notifications
sys.sql_expression_okuxhomekeka
ii-sys
sys.sql_modyuli
sys.foreign_key_ikholamu
izibalo
ii-sys
sts_columns
sys.work_order_columns
iisynonyms
sys.hash_indexes
iifayile_types
sys. ubume_kholamu
sys iitafile
sys.index_ikholamu
sys.trigger_event_types
ii-sys
sys.trigger_events
sys.key_constraints
ii-sys
sys.nenkqubo_yenkqubo_parameters
Ukujonga
sys.nani_enkqubo

Iingxelo:

  1. Ukujongwa kweKhathalogu yeNjongo (iTransact-SQL) ye SQL Server 2014
  2. Ukujongwa kweKhathalogu yeNjongo (iTransact-SQL) ye SQL Server 2012
  3. Ukujongwa kweKhathalogu yeNjongo (iTransact-SQL) ye SQL Server 2008 iR2
  4. Ukujongwa kweKhathalogu yeNjongo (iTransact-SQL) ye SQL Server 2008
  5. Ukujongwa kweKhathalogu yeNjongo (iTransact-SQL) ye SQL Server 2005