davidandrews13 (3/27/2012)
Carlo Romagnano (3/27/2012)
Easy question!Good practice is never use "SELECT * FROM" in view, too.
😉
surely it doesn't matter if you do SELECT *?
every time i create or update a view to '*' instead of naming each individual column name, it expands it out to the individual column names anyway.
and if you do want to bring back all columns, type * and let it expand out all the column names itself instead of manually typing them yourself.
Ah but if you drop a column from the underlying table, then SELECT * will not perform properly. So yes it does matter.