Thread: help! newbie coder
11-19-04, 09:48 #1Registered User
- Join Date
- Nov 2004
Unanswered: help! newbie coder
I am using ODBC connection into our Sybase tables, I would like to know if anyone can tell me what is the major difference between a view and a table, pros and cons in creating a view? I have read couple of post regarding views, what is the down side of creating a view using "SELECT * FROM T1"
By just using the pass-through query in Access, is there any command that allows me to tell whether the connection was a View or a table.
11-22-04, 03:43 #2Registered User
Provided Answers: 4Originally Posted by tanis97
- Join Date
- Jan 2004
A view becomes usefull if you create it with a select on multiple tables, or a limited number of columns of 1 table.
SELECT * FROM vw_table1 is much quicker to type than SELECT <20 columnnames here> FROM table1.
If you have a query that uses much joins and/or where-conditions, it can be very usefull to make a view for that. Save you typing all those lines of conditions, plus it is easier to read, 10 lines of code, or 1 line of code.
Good luck!I'm not crazy, I'm an aeroplane!