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

Tell us how many languages are supported by .net?

694

Explain the differences between vb.net and c#, related to oops concepts?

705

What is a stream in vb.net?

736

What is meant by jagged arrays?

754

What is visual basic.net culture?

713

What are the differences between server-side and client-side code?

727

Why do we use ansi keyword?

733

How do you define a read only property in a class module?

705

Can you please explain the difference between thread and process?

732

Explain the difference between int and int32?

690

described weak typing?

774

What are nested classes?

709

What is the difference between c# and vb.net?

754

Explain clr?

742

Tell me which namespace are used for accessing the data?

717