Don't get me wrong, but select * is the worst way to create a view.Becoz the select script with all colum name can be generated by sqlserver generate scripts.

Also its...