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

Explain about the performance of visual basic?

979

What is globalization?

920

Can you please explain the difference between int and int32?

995

i have two class that contain's two methods as same name in derived class i have to call these two methods what will happen at run time ?

2598

What is econo-jit?

1045

What is vb.net used for?

899

Explain the difference between thread and process?

919

Explain the components of common language runtime.

1054

Can you please explain the difference between c# and vb.net?

1016

What is the significance of delegates?

887

Explain the use of console application?

917

What is the difference between a "jagged array" and multidimensional array" ?can anyone show me it practically ?

912

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

958

What is the difference between vb 6 and vb.net?

1038

Before in my vb app I would just load the icons from dll. How can I load the icons provided by .net dynamically?

922