In addition to displaying the object creation-SQL script, SQL Prompt is highly customizable so you can make it perform exactly the way you want. It comes with intelligent code completion for fast, accurate script building, cross-database, linked-server query support, keyword formatting, code snippet integration, column picker among other features and integrates with SSMS, SSMS Express, Query Analyzer and Visual Studio 2005.
Click here for download....!