IT Community - Software Programming, Web Development and Technical Support

Drop view statement.

This is a discussion on Drop view statement. within the Database Support forums, part of the Web Development category; Hi all Can anyone explain what is sql drop view statement. Thanks in advance......


Go Back   IT Community - Software Programming, Web Development and Technical Support > Web Development > Database Support

Register FAQ Members List Calendar Mark Forums Read
  #1  
Old 03-25-2008, 08:18 PM
Pvinothkumar Pvinothkumar is offline
D-Web Analyst
 
Join Date: Sep 2007
Posts: 235
Pvinothkumar is on a distinguished road
Default Drop view statement.

Hi all


Can anyone explain what is sql drop view statement.


Thanks in advance...
Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
  #2  
Old 03-25-2008, 08:20 PM
itbarota itbarota is offline
D-Web Architect
 
Join Date: Jun 2007
Posts: 542
itbarota is on a distinguished road
Default Explain sql drop view statement.

Hi all...


The SQL DROP VIEW statement is the SQL command that removes an entire SQL view.


Thanks
Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
  #3  
Old 03-25-2008, 08:22 PM
itbarota itbarota is offline
D-Web Architect
 
Join Date: Jun 2007
Posts: 542
itbarota is on a distinguished road
Default Re: Drop view statement.

Hi all...


Can anyone tell me Why Use the SQL DROP VIEW Statement.


Thanks in advance...
Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
  #4  
Old 03-25-2008, 08:24 PM
Pvinothkumar Pvinothkumar is offline
D-Web Analyst
 
Join Date: Sep 2007
Posts: 235
Pvinothkumar is on a distinguished road
Default Why Use the SQL DROP VIEW Statement.

Hi all...



You may drop an view permanently when it is no longer useful or temporarily. If the view is not useful it could be dropped.

Also, if a view needs to be changed it would be dropped and then created again with changes in place.


Thanks...
Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
  #5  
Old 03-25-2008, 08:26 PM
itbarota itbarota is offline
D-Web Architect
 
Join Date: Jun 2007
Posts: 542
itbarota is on a distinguished road
Default Re: Drop view statement.

Hi all...


Can anyone tell me How to use the SQL DROP VIEW Statement.


Thanks in advance...
Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
  #6  
Old 03-25-2008, 08:27 PM
Pvinothkumar Pvinothkumar is offline
D-Web Analyst
 
Join Date: Sep 2007
Posts: 235
Pvinothkumar is on a distinguished road
Default How to use the SQL DROP VIEW Statement.

Hi all...

The SQL DROP VIEW command is used as follows.

SQL DROP VIEW Statement Syntax


DROP VIEW <view_name>


SQL DROP VIEW Statement Example

The following example drops a view named V_PERSON.

DROP VIEW V_PERSON

Thanks...
Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
  #7  
Old 03-24-2009, 06:16 AM
leveup2 leveup2 is offline
D-Web Trainee
 
Join Date: Mar 2009
Posts: 8
leveup2 is on a distinguished road
Default Re: Drop view statement.

is really useful for me
Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
Reply


Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are Off
Pingbacks are Off
Refbacks are Off

Similar Threads
Thread Thread Starter Forum Replies Last Post
Create View Statement itbarota Database Support 6 03-24-2009 06:16 AM
Taffic Drop vadivelanvaidyanathan Search Engine Optimization 0 01-23-2008 05:29 AM
JavaScript Drag and Drop rajkumar HTML, CSS and Javascript Coding Techniques 6 12-31-2007 12:43 AM
How to drop a datafile from a tablespace bluesky Database Support 0 11-03-2007 12:29 AM
Drop shadow effect using css muthukumar HTML, CSS and Javascript Coding Techniques 0 07-17-2007 11:43 AM


All times are GMT -7. The time now is 08:27 PM.


Copyright ©2004 - 2007, DiscussWeb. All Rights Reserved.
Our Partners
One Way Moving Companies | Stamford Dentist | Euro Millions Lottery | Home Loans| Furniture

SEO by vBSEO 3.0.0