Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
ushavellala
Starting Member
10 Posts |
 Posted - 2013-11-04 : 15:07:57
|
| Hello,I recently moved to a new job where we are using sql server 2005. In my previous job we were using 2008R2. In 2008 R2 while I was querying the table names, all the table names starting with the alphabet were displayed automatically. For Eg:Select * from CustomersWhen I write this query and start typing the table name, it gives me a list of all the tables whose names start from C. In don't see that option in 2005. Could you please let me know how to set that in 2005.Thanks in advance |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2013-11-04 : 15:19:09
|
| It's known as Intellisense, which isn't available in the SSMS 2005 tools unless you add software. Red Gate has SQL Prompt. Our very own Mladen has SSMS Tools Pack. I am sure there are others out there.Tara KizerSQL Server MVP since 2007http://weblogs.sqlteam.com/tarad/ |
 |
|
|
ushavellala
Starting Member
10 Posts |
Posted - 2013-11-04 : 16:38:56
|
| Thanks for your response. I will check those out!!Usha |
|
|
|
|
|
|
Get the table names while querying