![sql prompt options sql prompt options](https://www.sqlservercentral.com/wp-content/uploads/legacy/557ac8daf87cf0d0cccb6ed50d598b5c84d922a2/22500.png)
If I start describing every available option, this article will get real boring, real fast, but allow me to briefly laud this product's flexibility. As with its VBA counterpart, SQL Prompt works as you type.īefore we get started exploring the actual working function of this utility, we should mention the only menu selection of interest: the Options page. The bulk of the work is done automatically as you type, just as it does with IntelliSense in a VBA or Visual Basic module. There is also a menu that displays in SQL Server Management Studio, but this is only necessary for setting options and saving snippets. SQL Prompt, once installed, runs as a service and sports an icon in the system tray to declare its presence and to provide a convenient management interface.
#Sql prompt options code#
![sql prompt options sql prompt options](https://docs.oracle.com/cd/B10501_01/win.920/a92157/prompt.gif)
view and copy schema info & DDL scripts.apply keyword formatting while you type.insert column(s) from list of those available.insert table names from list of those available.Shortly after that, I was informed of the impending release of SQL Prompt and was very excited to get my hands on it. That's what you get with Red-Gate Software's new utility, SQL Prompt.īack in January, I reviewed SQL Refactor, also a Red-Gate product, of which I am very fond. Imagine having the convenience of IntelliSense TM from within SQL Server Management Studio. Well, it's not exactly the Holy Grail of SQL Server utilities, but it's close.