Motivation

• Improve object resolution when scripting a selected identifier so more SMO object types can be scripted correctly.
• Some database objects (synonyms, user-defined table types, user-defined types, and table-level triggers) were not handled by the previous lookup flow.
• Ensure triggers are located by scanning table triggers when the object is a SQL_TRIGGER.
• Make scripting work for more real-world selections beyond tables, procs and functions.

Description

• Added resolution branches for db.Synonyms, db.UserDefinedTableTypes, and db.UserDefinedTypes to the object lookup logic in ScriptSelectedObject.cs.
• Added trigger resolution via a new helper FindTableTrigger(Database db, string triggerName, string schemaName) that returns the matching SqlSmoObject from table triggers.
• Updated the lookup to treat objects with TypeDesc == "SQL_TRIGGER" specially and call FindTableTrigger when appropriate.
• Committed changes under the message: Handle more scriptable object types.

Testing

• No automated tests were run for this change.

Codex Task