filmov
tv
sys dm sql referencing entities in SQL Server
Показать описание
sql server referencing entities
sql server referenced objects
sql server schema bound dependency
sql server non schema bound dependency
In this video we will discuss
How to find object dependencies using the following dynamic management functions
Healthy diet is very important both for the body and mind. If you like Aarvi Kitchen recipes, please support by sharing, subscribing and liking our YouTube channel. Hope you can help.
Difference between
Referencing entity and Referenced entity
Schema-bound dependency and Non-schema-bound dependency
This is continuation to Part 131, in which we discussed how to find object dependencies using SQL Server Management Studio. Please watch Part 131 from SQL Server tutorial before proceeding.
The following example returns all the objects that depend on Employees table.
Difference between referencing entity and referenced entity
A dependency is created between two objects when one object appears by name inside a SQL statement stored in another object. The object which is appearing inside the SQL expression is known as referenced entity and the object which has the SQL expression is known as a referencing entity.
The following query returns all the referenced entities of the stored procedure sp_GetEmployeesandDepartments
Please note : For both these dynamic management functions to work we need to specify the schema name as well. Without the schema name you may not get any results.
Difference between Schema-bound dependency and Non-schema-bound dependency
Schema-bound dependency : Schema-bound dependency prevents referenced objects from being dropped or modified as long as the referencing object exists
Example : A view created with SCHEMABINDING, or a table created with foreign key constraint.
Non-schema-bound dependency : A non-schema-bound dependency doesn't prevent the referenced object from being dropped or modified.
Link for all dot net and sql server video tutorial playlists
Link for slides, code samples and text version of the video
sql server referenced objects
sql server schema bound dependency
sql server non schema bound dependency
In this video we will discuss
How to find object dependencies using the following dynamic management functions
Healthy diet is very important both for the body and mind. If you like Aarvi Kitchen recipes, please support by sharing, subscribing and liking our YouTube channel. Hope you can help.
Difference between
Referencing entity and Referenced entity
Schema-bound dependency and Non-schema-bound dependency
This is continuation to Part 131, in which we discussed how to find object dependencies using SQL Server Management Studio. Please watch Part 131 from SQL Server tutorial before proceeding.
The following example returns all the objects that depend on Employees table.
Difference between referencing entity and referenced entity
A dependency is created between two objects when one object appears by name inside a SQL statement stored in another object. The object which is appearing inside the SQL expression is known as referenced entity and the object which has the SQL expression is known as a referencing entity.
The following query returns all the referenced entities of the stored procedure sp_GetEmployeesandDepartments
Please note : For both these dynamic management functions to work we need to specify the schema name as well. Without the schema name you may not get any results.
Difference between Schema-bound dependency and Non-schema-bound dependency
Schema-bound dependency : Schema-bound dependency prevents referenced objects from being dropped or modified as long as the referencing object exists
Example : A view created with SCHEMABINDING, or a table created with foreign key constraint.
Non-schema-bound dependency : A non-schema-bound dependency doesn't prevent the referenced object from being dropped or modified.
Link for all dot net and sql server video tutorial playlists
Link for slides, code samples and text version of the video
0:08:05
sys dm sql referencing entities in SQL Server
0:11:19
sys dm sql referencing entities in SQL Server in arabic
0:05:41
List Object Dependencies using SQL referencing Entity
0:01:33
Find References to a Column in SQL Server Database Code
0:02:51
1 sys dm exec sql text
0:04:07
sys.objects vs sys.all_objects in Sql Server
0:02:51
1 - sys.dm_exec_sql_text
0:01:49
Find all procedures having table reference in sql server
0:05:09
3 sys dm exec connections
0:12:28
Returning cross-database dependencies in Sql Server
0:03:00
SQL Server: sys.syscomments, sys.sysobjects and findtext
0:01:14
SQL : How does sys.dm_exec_sql_text work?
0:04:01
Uses of sys.sysdatabases in SQL Server
0:02:35
2 - sys.dm_exec_query_plan
0:00:35
How to check the dependencies of a MS SQL database table
0:06:29
sys.Objects vs sysobjects in SQL Server
0:09:17
sys.Databases vs sys.sysDatabases in Sql Server
0:02:56
SQL Server System Objects
0:03:15
Using an sql statement instead of an entity name
0:01:48
What are the undocumented values for referencing_class in sys.sql_expression_dependencies?
0:05:09
3 - sys.dm_exec_connections
0:01:24
SQL : Difference between Information_schema vs sys tables in SQL Server
0:05:09
sp depends in SQL Server
0:01:07
SQL : How to give a user access to sys.master_files in SQL Server?
Комментарии