New DB views only showing *(all columns)
-
I have a small problem here.
Has anyone ever newly created a DB, and every time you want to create a view
all you see when adding tables is the box with name of table and inside instead of all the columns showing up you get [ ] *(All columns)
There seams to be some ways of working with this but it presents a lot of hassle.
-
I don't build my queries that way, so I've not seen that. I just type them out myself. I've had so many problems with the graphical query designer that I don't trust it, don't like it, and don't use it.
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
-
If I may elaborate:
Even threw the Qu-An. when I create a view that is the result.
Also, every table in my view has a _1 tied to it.
I should note that I do not have duplicate tables.
I can manualy remove the _1 (s). But all the tables still have there columns hidden. This is the work around I had mentioned. But it presents problems when it comes to editing.
-
Perhaps I'll suggest to my superior we should re do the DB. There does seam to be something way off.
Especially when any way I create a view it results in all it's tables not showing their columns and all tables being renamed with _1 at the end.
-
davboudreau (4/6/2009)
I have a small problem here.Has anyone ever newly created a DB, and every time you want to create a view
all you see when adding tables is the box with name of table and inside instead of all the columns showing up you get [ ] *(All columns)
There seams to be some ways of working with this but it presents a lot of hassle.
I beleive that this indicates either that the table has no columns or that the columns are not accessible to you.
Perhaps you or someone else has the table open in a table design wizard window somewhere?
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font] -
I am ready to accept any possible cause at this point.
Boss even went in there on the admin account and same thing happens to him.
I was hoping this was a common problem with a known option I could verify.
-
Common? No. But most of us do not use the query expression wizard that often, it's just faster (and easier, IMHO) to type the queries yourself once you know the SELECT syntax well enough.
However, as I said, I would be strongly suspicious of someone having the table's defintion locked out, which the table design wizard does.
Try using SP_LOCK to see if any thing is locked.
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font] -
That's a good plan dude.
Oh I'm preparing these views for another peace of software...I'm not simply looking to spit out data.
Thank you for the help.
Viewing 8 posts - 1 through 7 (of 7 total)
You must be logged in to reply to this topic. Login to reply