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 (permalink)  
Old 03-25-2008, 08:18 PM
Pvinothkumar Pvinothkumar is offline
D-Web Analyst
 
Join Date: Sep 2007
Posts: 237
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
Sponsored Links
  #2 (permalink)  
Old 03-25-2008, 08:20 PM
itbarota itbarota is offline
D-Web Architect
 
Join Date: Jun 2007
Posts: 547
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 (permalink)  
Old 03-25-2008, 08:22 PM
itbarota itbarota is offline
D-Web Architect
 
Join Date: Jun 2007
Posts: 547
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 (permalink)  
Old 03-25-2008, 08:24 PM
Pvinothkumar Pvinothkumar is offline
D-Web Analyst
 
Join Date: Sep 2007
Posts: 237
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 (permalink)  
Old 03-25-2008, 08:26 PM
itbarota itbarota is offline
D-Web Architect
 
Join Date: Jun 2007
Posts: 547
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 (permalink)  
Old 03-25-2008, 08:27 PM
Pvinothkumar Pvinothkumar is offline
D-Web Analyst
 
Join Date: Sep 2007
Posts: 237
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
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 On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Create View Statement itbarota Database Support 5 03-25-2008 08:15 PM
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 02:10 PM.


Copyright ©2004 - 2007, DiscussWeb. All Rights Reserved.

SEO by vBSEO 3.0.0