SQL Server equivalent to Oracle’s CREATE OR REPLACE VIEW

by

The solutions above though they will get the job done do so at the risk of dropping user permissions. I prefer to do my create or replace views or stored procedures as follows.

IF NOT EXISTS (SELECT * FROM sys.views WHERE object_id = OBJECT_ID(N'[dbo].[vw_myView]'))
    EXEC sp_executesql N'CREATE VIEW [dbo].[vw_myView] AS SELECT ''This is a code stub which will be replaced by an Alter Statement'' as [code_stub]'
GO

ALTER VIEW [dbo].[vw_myView]
AS
SELECT 'This is a code which should be replaced by the real code for your view' as [real_code]
GO

More Related Contents:

  1. Updating image in VB and SQL Server not working [closed]
  2. If condition in SQL Server 2008
  3. Compare the values of column in SQL Server
  4. Search all tables, all columns for a specific value SQL Server [duplicate]
  5. When/Why to use Cascading in SQL Server?
  6. SQL WHERE.. IN clause multiple columns
  7. SQL Update with row_number()
  8. SQL Server: combining multiple rows into one row
  9. Database scheme, autoincrement
  10. SQL Server: Index columns used in like?
  11. How can I select from list of values in SQL Server
  12. Configure Lucene.Net with SQL Server
  13. SQL Server tables: what is the difference between @, # and ##?
  14. Recursive sum in tree structure
  15. Getting execute permission to xp_cmdshell
  16. Why does my ODBC connection fail when running an SSIS load in Visual Studio but not when running the same package using Execute Package Utility
  17. Why the SQL Server ignore the empty space at the end automatically?
  18. Import / Export database with SQL Server Server Management Studio
  19. Sql Server – connect with windows authentication
  20. SQL Server ON DELETE Trigger
  21. “Cannot open user default database. Login failed.” after installing SQL Server Management Studio Express
  22. SQL Server – Auto-incrementation that allows UPDATE statements
  23. FOR XML PATH(”): Escaping “special” characters
  24. Unable to login to SQL Server + SQL Server Authentication + Error: 18456
  25. Instead of trigger in SQL Server loses SCOPE_IDENTITY?
  26. Convert a string with ‘YYYYMMDDHHMMSS’ format to datetime
  27. “No backupset selected to be restored” SQL Server 2012
  28. Update SQL with consecutive numbering
  29. Nested transactions in Sql Server
  30. Count number of records returned by group by

Leave a Comment