DF026: The schema name for procedure or function is not specified.
The topic describes the DF026 T-SQL code analysis rule.
Category
BEST PRACTICE
Message
The schema name for a procedure or function is not specified.
Description
It is recommended to explicitly specify the schema when referencing a stored procedure or user-defined function.
Additional information
Explicitly stating the schema name helps prevent potential conflicts with objects in different schemas and enhances code readability. Additionally, specifying the schema can improve query performance by reducing the need for the database engine to resolve object references.
Noncompliant code example
SELECT * FROM DemoFunction()
DEClARE @result NVARCHAR(50)
EXEC @result = DemoProcedure
Compliant solution
SELECT * FROM dbo.DemoFunction()
DEClARE @result NVARCHAR(50)
EXEC @result = dbo.DemoProcedure
Want to Find out More?
Overview
Take a quick tour to learn all about the key benefits delivered by dbForge Studio for SQL Server.
All features
Get acquainted with the rich features and capabilities of the Studio in less than 5 minutes.
Request a demo
If you consider employing the Studio for your business, request a demo to see it in action.
Ready to start using dbForge Studio for SQL Server?