After you define a view, you can modify its definition in the Database Engine without dropping and re-creating the view. Modifying a view doesn't affect any dependent objects, such as stored ...

When you rename a trigger, the trigger must be in the current database, and the new name must follow the rules for [identifiers](../databases/database-identifiers.md).