Skip to content
← SQL Prompt

How can we improve SQL Prompt?

SQL Prompt: Script object as alter

Categories

JUMP TO ANOTHER FORUM

(thinking…)

Suggestions window should display CREATE sql for CLR objects

No CREATE SQL is displayed in the suggestions window when hovering over any CLR objects, or scripting the object as alter. The code returned is just a comment saying:

-- No creation SQL available for this object type

The CREATE/ALTER statement can easily be built by querying the relevant system tables. SSMS does it when you script the object and other Redgate products such as SQL Compare and SQL Source Control do it just fine, not sure why SQL Prompt would have been left out.

1 vote

We're glad you're here

Please sign in to leave feedback
Signed in as (Sign out)
Close
Close

We’ll send you updates on this idea

James Penman shared this idea  ·   ·  Report…  ·  Admin →
How important is this to you?

We're glad you're here

Please sign in to leave feedback
Signed in as (Sign out)
Close
Close

We're glad you're here

Please sign in to leave feedback
Signed in as (Sign out)
Close
Close
Submitting...
An error occurred while saving the comment
  • James Penman commented  ·   ·  Report

    Any movement on this at all? It seems like quite an oversight and an easy thing to implement considering every other Redgate product generates CLR object scripts just fine.