Dropping a view

Question

Dropping a view

Steve Jones - SSC Editor

SSC Guru

Points: 736270
More actions
November 10, 2016 at 10:00 pm

#337199

Comments posted to this topic are about the item Dropping a view
November 10, 2016 at 10:01 pm

This was removed by the editor as SPAM

Viewing 10 posts - 1 through 9 (of 9 total)

You must be logged in to reply to this topic. Login to reply

George Vobr SSCrazy Eights Points: 9998 More actions · Answer 1

Quite useful question, thanks Steve. But I was groping a while in the article "Looking at views, Close Up",

Dropping Views paragraph until I figured out that here is described the syntax e.g. for PostgreSQL and not for SQL Server... :ermm:

See in https://www.postgresql.org/docs/8.1/static/sql-dropview.html

Sean Lange SSC Guru Points: 286590 More actions · Answer 2

Somebody has to mention that you should never end up in this situation in the first place because nested views are a performance timebomb.

_______________________________________________________________

Need help? Help us help you.

Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.

Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.

Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/

Ed Wagner SSC Guru Points: 287026 More actions · Answer 3

Sean Lange (11/11/2016)
Somebody has to mention that you should never end up in this situation in the first place because nested views are a performance timebomb.

Yes they are. I've seen horrible things happen with nested views.

Edit: Oh yeah. A good, straightforward question is a nice way to end the week. Thanks, Steve.

Tally Tables - Performance Personified
String Splitting with True Performance
Best practices on how to ask questions

Sean Lange SSC Guru Points: 286590 More actions · Answer 4

Ed Wagner (11/11/2016)
A good, straightforward question is a nice way to end the week. Thanks, Steve.

Agreed!!! Good question Steve!!

_______________________________________________________________

Need help? Help us help you.

Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.

Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.

Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/

Eirikur Eiriksson SSC Guru Points: 182912 More actions · Answer 5

Good question and a good case for using WITH SCHEMABINDING when creating a view.

😎

akljfhnlaflkj SSC Guru Points: 76202 More actions · Answer 6

Eirikur Eiriksson (11/14/2016)
Good question and a good case for using WITH SCHEMABINDING when creating a view.
😎

Agreed!

dstrickrott SSCommitted Points: 1951 More actions · Answer 7

Eirikur Eiriksson (11/14/2016)
Good question and a good case for using WITH SCHEMABINDING when creating a view.
😎

+1

Koen Verbeeck SSC Guru Points: 259105 More actions · Answer 8

Easy one, thanks.

Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP