System Ntxhuav nyob hauv SQL Server Cov ntaub ntawv MDF thiab NDF

In SQL Server Cov chaw khaws ntaub ntawv MDF thiab NDF, muaj ntau qhov system cov qauv siv los khaws cov qauv thiab lwm cov ntaub ntawv meta ntawm cov teev.

Hauv qab no yog cov npe cov lus uas siv cov txheej txheem txhua zaus:

System Lub Npe Lub Npe
sys.allocation_units
sys.objects
sys.assembly_modules
sys.parameters
sys.check_constraints
sys.partitions
sys.column
sys.procedures
sys.computed_columns
sys.qhov tshwm sim
sys.default_constraints
sys.service_queues
sys.events
sys.sql_vaj
sys.event_notifications
sys.sql_expression_ntseeg
sys.extended_ txheej txheem
sys.sql_modules
sys.foreign_key_columns
sys.stats
sys.foreign_key
sys.stats_columns
sys.function_order_columns
sys.synonyms
sys.hash_indexes
sys.table_types
sys.identity_column
sys.tables
sys.index_columns
sys.trigger_event_types
sys.indexes
sys.trigger_events
sys.key_constraints
sys.triggers
sys.numbered_procedure_parameters
sys.saib
sys.numbered_ txheej txheem

References:

  1. Lub Hom Phiaj Saib Cov Ntawv Teev (Transact-SQL) rau SQL Server 2014
  2. Lub Hom Phiaj Saib Cov Ntawv Teev (Transact-SQL) rau SQL Server 2012
  3. Lub Hom Phiaj Saib Cov Ntawv Teev (Transact-SQL) rau SQL Server 2008 R2
  4. Lub Hom Phiaj Saib Cov Ntawv Teev (Transact-SQL) rau SQL Server 2008
  5. Lub Hom Phiaj Saib Cov Ntawv Teev (Transact-SQL) rau SQL Server 2005