CREATE VIEW table_name [ ( column_name1, column

how to create views in sql with syntax and example

Question Posted / v.vaithyanarayanan

Answer Posted / v.vaithyanarayanan

CREATE VIEW table_name [ ( column_name1,
column_name2, ... ) ]
AS SELECT ...

EX:
CREATE VIEW ViewOfTableA AS SELECT col1 FROM TableA

Is This Answer Correct ?

0 Yes

0 No

Please Help Members By Posting Answers For Below Questions

What keyword is used to accept a variable number of parameter in a method?

1013

What are the shadow variables?

1052

What is the difference between Namespace and Assembly?

1133

What is break mode? What are the options to step through code?

1052

Explain the observations between vb.net and vc#.net?

921

What is the importance of a Button control?

1298

difference between control and component more than one differences

3031

What is the advantages of VB.NET?

1035

How to retrieve images in sql server database through vb.net?

965

What is static member?

1002

Explain the use of console application?

958

How to view an assembly?

958

what is commom language runtime?

961

What is tracing?

1127

Explain nested classes?

958