Menu
Is there any FREE "build-in" way to capitalize the "keywords" in the SQL 2005/2008 management studio when you write a sql query?
i.e
truncate table x
should be automatically changed to:
TRUNCATE TABLE x
659
What I do is I select the word and hit CTRL+SHIFT+U and it SSMS immediately changes the case of the selected word. Similar way if one want to convert cases to lower case, another short cut CTRL+SHIFT+L is also available.
Keywords in SQL are case-insensitive for the most popular DBMSs. The computer doesn't care whether you write SELECT , select, or sELeCt ; so, in theory, you can write however you like.
the intellisense in the 2008 management studio will do this as well as long as you are connected to a SQL 2008 database.
You can change the case you prefer to upper or lower under Tools / Options / Text Editor / Transact-SQL / IntelliSense
68
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
