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 |
|
|
|
|
|