Abstract
This chapter contains a few recipes that you can use tomaintain database objects and view object dependencies. You’ll see recipes used to
-
Change the name of user-created database objects.
-
Change an object’s schema.
-
Display information about object dependencies via the new SQL Server 2008 sys.sql_expression_dependencies view and DynamicManagement Views sys.dm_sql_referenced_entities and sys.dm_sql_referencing_entities.
This is a preview of subscription content, log in via an institution to check access.
Access this chapter
Tax calculation will be finalised at checkout
Purchases are for personal use only
Preview
Unable to display preview. Download preview PDF.
Rights and permissions
Copyright information
© 2008 Joseph Sack
About this chapter
Cite this chapter
(2008). Maintaining Database Objects and Object Dependencies. In: SQL Server 2008 Transact-SQL Recipes. Apress. https://doi.org/10.1007/978-1-4302-0625-5_24
Download citation
DOI: https://doi.org/10.1007/978-1-4302-0625-5_24
Publisher Name: Apress
Print ISBN: 978-1-59059-980-8
Online ISBN: 978-1-4302-0625-5
eBook Packages: Professional and Applied ComputingProfessional and Applied Computing (R0)Apress Access Books