System versus SQL name, Part 2: Accessing database objects

When running SQL statements, you can run them either using system or SQL naming convention. The previous article was focused on the differences in ownership and access authorities
when creating database objects with the SQL and system naming convention. This article examines the behavior differences with system and SQL naming when accessing tables and views as well
as stored procedures and user-defined functions (UDFs), focusing mainly on the different behaviors when using unqualified references to those objects.


  • No Related Posts

Leave a Reply