-
New view not showing columns
Any idea why I cannot see (in Enterprise Manager) all the coulmns of a selected table? All I get is * all columns - not each one, meaning I cannot select individual columns in my new view. Could it be the version? I am running SQL 7.0 SP1
Thanks
-
New view not showing columns (reply)
Is your View doing a SELECT * ? If so this may be the problem. Use SELECT Column1, Column2 etc..
Also, I would suggest being on at least SP2.
Rick
------------
Rachel at 7/9/01 6:56:18 PM
Any idea why I cannot see (in Enterprise Manager) all the coulmns of a selected table? All I get is * all columns - not each one, meaning I cannot select individual columns in my new view. Could it be the version? I am running SQL 7.0 SP1
Thanks
-
New view not showing columns (reply)
Thanks for your response Rick. It's a new view I am trying to create - I don't get any choice on what cloumns to select - there's only *. I have since discovereed that this only applies to the one database on this server. If I try to create a new view in another db on the same server, I do get the option of selecting coulmns. Perhaps there is a db option or config setting?
------------
RickD at 7/10/01 8:26:03 AM
Is your View doing a SELECT * ? If so this may be the problem. Use SELECT Column1, Column2 etc..
Also, I would suggest being on at least SP2.
Rick
------------
Rachel at 7/9/01 6:56:18 PM
Any idea why I cannot see (in Enterprise Manager) all the coulmns of a selected table? All I get is * all columns - not each one, meaning I cannot select individual columns in my new view. Could it be the version? I am running SQL 7.0 SP1
Thanks
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
|