Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

View not showing all columns of a table in design view???

Status
Not open for further replies.

Giovaanni

Programmer
Oct 31, 2002
6
US
Hi,

I'm setting up a view and in design view I add a table. When it comes up graphically it only shows the (* all columns) in the table and no other column names for that table regardless of how many it has. When I do the same thing on the Northwind sample Database I can see all the columns for any view I create. What is going on to cause this problem and how can I correct it without typing a bunch of code. I'd rather create and modify views through the graphical interface in the design view of Enterprise Manager for SQL Server than type all of the code for it. Can anyone help? Thanks in advance,

Mark.
 
This was remedied by eliminating spaces from the database name. Problem solved :)
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top