sp_depends UseOthers--Object does not reference any object, and no objects reference it. sp_depends UseMe--error:The object 'UseMe' does not exist in database 'test' or is invalid for this operation. --之后补充这个被调用的存储过程 create procedure UseMe @flag nvarchar(50) as begin sele...
This feature will be removed in a future version of Microsoft SQL Server. Avoid using this feature in new development work, and plan to modify applications that currently use this feature. Use sys.dm_sql_referencing_entities and sys.dm_sql_referenced_entities instead. Transact-SQL Syntax Conventi...
sp_depends (Transact-SQL) Article 2023-03-01 8 contributors Feedback In this article Syntax Arguments Return Code Values Result Sets Show 3 more Applies to: SQL Server Displays information about database object dependencies, such as the views and procedures that depend on a table or...
This feature will be removed in a future version of Microsoft SQL Server. Avoid using this featur...
Related resources for SQL SpDepends Some Useful System Stored Procedures in SQL Server 20127/2/2019 6:30:16 AM. This article provides a brief introduction to various system Stored Procedures in SQL Server.About Us Contact Us Privacy Policy Terms Media Kit Sitemap Report a Bug FAQ Partners ...
In this article Syntax Arguments Return code values Result set Show 3 more Applies to:SQL Server Displays information about database object dependencies, such as the views and procedures that depend on a table or view, and the tables and views that are depended on by the view or procedure. ...
In this article Syntax Arguments Return code values Result set Show 3 more Applies to:SQL Server Displays information about database object dependencies, such as the views and procedures that depend on a table or view, and the tables and views that are depended on by the view or procedure. ...
In this article Syntax Arguments Return code values Result set Show 3 more Applies to:SQL Server Displays information about database object dependencies, such as the views and procedures that depend on a table or view, and the tables and views that are depended on by the...
In the current database, the specified object references the following: Name type updated selected column --- Dbo.ufnLeadingZeros scalar function no no NULL Sales.Customer user table no no CustomerID In the current database, the specified object is referenced by the following: name type --- ...
This feature will be removed in a future version of SQL Server. Avoid using this feature in new development work, and plan to modify applications that currently use this feature. Use sys.dm_sql_referencing_entities and sys.dm_sql_referenced_entities instead.Transact...