Hi,
While Creating view you need to specify the Details through SELECT Statement,Without SELECT Statement you can't Create VIEW.
CREATE
[OR REPLACE]
[ALGORITHM = {UNDEFINED | MERGE | TEMPTABLE}]
[DEFINER = { user | CURRENT_USER }]
[SQL SECURITY { DEFINER | INVOKER }]
VIEW view_name [(column_list)]
AS select_statement
[WITH [CASCADED | LOCAL] CHECK OPTION]
In View Creation select_statement is mandatory. So
"SELECT" Statement is Must.
Read the following links for VIEWs.
CREATE VIEW Syntax[
^]
SQL Views[
^]
Views[
^]
Different Types of SQL Server Views[
^]
Regards,
GVPrabu