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 |
|
spthomas
Starting Member
14 Posts |
 Posted - 2010-09-27 : 18:00:27
|
| I was reviewing some view definitions that are supposed to be working, and in the From clause they have names in this format:dbname..tablenameShouldn't that bedbname.dbo.tablenameThe schema for all these tables is dbo.?? |
|
|
Skorch
Constraint Violating Yak Guru
300 Posts |
Posted - 2010-09-27 : 18:19:14
|
| I just tried it and both ways work.Some days you're the dog, and some days you're the fire hydrant. |
 |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2010-09-27 : 19:44:12
|
| It's a shorthand for dbo, left over from the Sybase days. It's probably better to put and explicit dbo in there if you can. |
|
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
|
|
harsh_athalye
Master Smack Fu Yak Hacker
5581 Posts |
Posted - 2010-09-28 : 11:07:32
|
Madhi,For the first time ever, I got to see your pic on your blog there!  Harsh Athalyehttp://www.letsgeek.net/ |
|
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2010-09-28 : 12:56:48
|
quote:
Originally posted by harsh_athalye
Madhi,For the first time ever, I got to see your pic on your blog there! Harsh Athalyehttp://www.letsgeek.net/
It means you haven't seen my MVP profile MadhivananFailing to plan is Planning to fail |
|
|
|
|
|
|
".." standin for schema?