CREATE VIEW table_name [ ( column_name1, column

how to create views in sql with syntax and example

Question Posted / v.vaithyanarayanan

5 Answers
9878 Views
I also Faced
E-Mail Answers

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

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

Name and explain some of the exclusive features which are present in vb?

956

how many server control present in .net

2760

Explain the difference between thread and process?

992

What are the different types of applications supported in .net (or) .net framework?

944

What is the difference between manifest and metadata?

1060

Explain about visual basic?

981

What is the significance of delegates?

963

What is stack used for in vb. Net?

941

Explain clr?

1045

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

972

Explain about Visual basic.NET culture?

993

Explain the difference between namespace and assembly?

1004

Explain the difference between system.string and system.stringbuilder classes?

993

Define clr?

1056

what is the need for dynamic controls in vb.net? i would like to know for what purpose should we create the controls dynamically? please give the answer in simple words.

2380