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 |
|
Peter99
Constraint Violating Yak Guru
498 Posts |
 Posted - 2013-01-14 : 18:59:32
|
| Hi,In SSMS, query analyzer, when I write select * from .... it does not display tables/synonym. I think it should display table/synonym name when I start writing select * from then it should show table or synonym where I have access in that database? Is there any setting on server or database level? It pop ups database names but not tables/synonym. (Windows 2008 R2, SQL Server 2008 R2)Thanks |
|
|
Peter99
Constraint Violating Yak Guru
498 Posts |
Posted - 2013-01-14 : 19:29:47
|
| When I select * from it shows table names but not synonym names. I want to show table names as well as synonym names. Any help. |
 |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2013-01-15 : 00:18:58
|
| only after you select database and put . it will populate schema names. once you put a . after that you should get tablenamesthe three part naming convention isSELECT * FROM DBName.SchemaName.ObjectName------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
|
|
|
Peter99
Constraint Violating Yak Guru
498 Posts |
Posted - 2013-01-15 : 10:10:04
|
| I can get table names when I type select * from dbo. but cannot get synonym names. |
|
|
|
|
|
|
table or synonym display