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.columns |
sys.procedures |
sys.computed_columns |
sys.sequences |
sys.default_constraints |
sys.service_queues |
sys.events |
sys.sql_dependencies |
sys.event_notifications |
sys.sql_expression_dependencies |
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.numbered_procedure_parameters |
sys.views |
sys.numbered_procedures |
References:
- Lub Hom Phiaj Saib Cov Ntawv Teev (Transact-SQL) rau SQL Server 2014
- Lub Hom Phiaj Saib Cov Ntawv Teev (Transact-SQL) rau SQL Server 2012
- Lub Hom Phiaj Saib Cov Ntawv Teev (Transact-SQL) rau SQL Server 2008 R2
- Lub Hom Phiaj Saib Cov Ntawv Teev (Transact-SQL) rau SQL Server 2008
- Lub Hom Phiaj Saib Cov Ntawv Teev (Transact-SQL) rau SQL Server 2005