SQL Server
Version 5.3.0
Changed
- A create is a create.
CREATE FUNCTION,CREATE PROCEDURE,CREATE VIEW, andCREATE TRIGGERrender withoutOR ALTERwhen the plan is creating;CREATE OR ALTERrenders only for the replace and recreate actions, where the plan knows the object exists. (A changed trigger plans as a replacement, renderedCREATE OR ALTER.) A create colliding with an object the plan didn’t know about now fails loudly instead of silently overwriting it.