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 |
|
indupriyav
Starting Member
13 Posts |
 Posted - 2013-09-30 : 06:53:01
|
| Im an Oracle person.I started working in SQL server recently. Dont have prior experience.Just need understanding abilities.I select data from a SQL table asselect count(*)from [Myclient].[data].CUST_INVBut when I see the tables under Myclient.data in object explorer, I just see CUST_INV_Current, CUST_INV_Upload etc.The total no of rows in CUST_INV and CUST_INV_Current is same.Is there any alias(In oracle it is synonym) being set somewhere. Where can I see it ,to check whether these two tables are same?indupriyav |
|
|
webfred
Master Smack Fu Yak Hacker
8781 Posts |
Posted - 2013-09-30 : 07:07:52
|
Maybe CUST_INV is a view? Have a look in object explorer...
Too old to Rock'n'Roll too young to die. |
 |
|
|
indupriyav
Starting Member
13 Posts |
Posted - 2013-09-30 : 07:25:57
|
| Yes its a view.Good Catch.Thanks.indupriyav |
|
|
|
|
|
|
Basic Query