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

Can you please explain the difference between value and reference types?

530

What are the different variables in vb.net?

526

What is DLL HELL in VB.NET

617

What is a static class?

602

What is sorting in vb?

530

Explain the difference between import system.data.sqlclient and system.data.oledb?

559

Define clr?

553

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

527

Explain the use of option explicit?

603

What do you mean by Redim in VB.NET?

678

What is trace in vb.net?

591

What is the significance of delegates?

524

What are the different types of Lock available in Visual Basic?

642

What is the advantage of using system.text.stringbuilder over system.string?

618

Can you please explain the difference between int and int32?

572