GeekInterview.com
Series: Subject: Topic:
Question: 8 of 118

Can i update views in SQL

Can i update views in SQL if yes in what scenarios? if your view is joining multiple tables
Asked by: rahul.solanke | Member Since Jan-2012 | Asked on: Jan 14th, 2012

View all questions by rahul.solanke

Showing Answers 1 - 3 of 3 Answers
suji

Answered On : Jan 15th, 2012

View all questions by suji   View all answers by suji

Yes. You can just create view and treat as table. Use update statements like you do for tables.

  
Login to rate this answer.
Jean Daniel Joseph

Answered On : Jan 17th, 2012

Yes but you remember views, represents a virtual table but if you delete the table you wont be able to update the view

  
Login to rate this answer.
abinay

Answered On : Oct 6th, 2012

yes,we can update the view as like a table.view is virtual table,basically it is not having any storage data. in a view data will be coming from table.if u delete the table .we wont update the view.

  
Login to rate this answer.

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.

Related Answered Questions

Related Open Questions

User Panel

Register
Login
Lost Password
Get Activation Code

Categories

Btrieve

Clipper

Database Admin

Firebird

Informix

Microsoft Access

MYSQL

PostgreSQL

Progress

SAP DB

SQL

SQL Server

Stored Procedures

Sybase

Teradata

Unify

Interview Coaching

Career Options for BCA Graduates

What will you do when you are not able to get your message across to your audience?

How do you deal and overcome major challenges?

What are the things you wish to achieve in 5 years?

Provide an example of a goal that you successfully attained.

Give me good reasons why should I choose you over others.

Describe a time when you had to convince a friend ?

What are my options when I do not get a job after graduation?

Describe a time when you had to work under pressure.

Tell me about a skill you recently acquired or improved.

Ads

Connect

twitter fb Linkedin GPlus RSS

Ads

Interview Question

 Ask Interview Question?

 

Latest Questions

Interview & Career Tips

Get invaluable Interview and Career Tips delivered directly to your inbox. Get your news alert set up today, Once you confirm your Email subscription, you will be able to download Job Inteview Questions Ebook . Please contact me if you there is any issue with the download.

Subscribe