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 |
|
Xcopy
Starting Member
2 Posts |
 Posted - 2009-04-07 : 13:11:10
|
| We've just created a new DB, all tables are in place and as per sp_lock nothing seams locked. We have to prepare a number of views for some external applications. When I create a view and start selecting tables I notice one thing first, the tables get imported but only show the name of the table and inside the table box there's only *(all columns) listed.These tables are ok because the test DB houses an exact copy. Here is the next thing I notice.As I am adding tables in the query itself the table names all have _1 tied to them. I don't see any table duplications anywhere in the DB. I can manually remove these _1 but the table columns remain hidden. It makes for a lot of hassle =)(this situation occurs both in design view and in query analyzer) Has anyone ever come across this, and thank you for your time. |
|
|
Xcopy
Starting Member
2 Posts |
Posted - 2009-04-16 : 13:57:39
|
| UPDATE / SOLUTION I should have been more exact in my description. Here was the problem. the Database was created with a period in the name ie: Floor.One This for some reason was creating another level of detail in the structure. like BackGround.ColorWhen creating a view, the database was looking for tables in One instead of Floor. Not finding the tables it added _1 to all tables and made the view highly un usable. Renamed the DB and all is well now. |
 |
|
|
|
|
|
New DB views are not showing table columns