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 do you mean by Redim in VB.NET?

665

What is vb.net used for?

547

What is the purpose of an Assembly?

592

What is a preprocessor directive in vb.net?

538

What are all the parts of .net framework?

520

Explain about branching logic control in vb.net?

533

Is vb net a scripting language?

539

what is difference between web.config and machine.config and where it will be ?

475

Write a VB.Net console program to check whether a number is perfect or not.

6927

What is sealed class?

597

What is the use of errorprovider control?

588

What do you mean by option strict on?

660

List the different types of assembly?

539

What are the features of c# which are not present in vb.net?

650

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

497