altering procedures/sequence/triggers commands

Posted on 2005-04-20
Last Modified: 2010-03-19
I just want simple commands on how to alter the above as I have to run them against the current live database.

I know in oracle its create or replace am as sql server dummy!

any ideas?

Question by:Etravels
    LVL 6

    Expert Comment

    ALTER PROCEDURE or ALTER TRIGGER, the rest of the command is identical with corresponding CREATE statement.
    LVL 23

    Expert Comment

    LVL 68

    Accepted Solution

    That is, there is not a "CREATE OR REPLACE" or "CREATE OR ALTER" option in SQL Server.  If the object exists, you must specify ALTER; if it doesn't exist, you must use CREATE.

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    PRTG Network Monitor: Intuitive Network Monitoring

    Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

    When you hear the word proxy, you may become apprehensive. This article will help you to understand Proxy and when it is useful. Let's talk Proxy for SQL Server. (Not in terms of Internet access.) Typically, you'll run into this type of problem w…
    The Delta outage: 650 cancelled flights, more than 1200 delayed flights, thousands of frustrated customers, tens of millions of dollars in damages – plus untold reputational damage to one of the world’s most trusted airlines. All due to a catastroph…
    This videos aims to give the viewer a basic demonstration of how a user can query current session information by using the SYS_CONTEXT function
    Using examples as well as descriptions, and references to Books Online, show the documentation available for datatypes, explain the available data types and show how data can be passed into and out of variables.

    737 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    22 Experts available now in Live!

    Get 1:1 Help Now