character limitations on sp name, & function name

  • Is there any limitation that how many characters should we give for stored procedure name, view name, and function name?.

    and if we give more characters on sp name, and function name, will it effect the performance? (this is a doubt.)

    Please guide me on that..

    Regards,

    Ramani

  • Hi,

    Maximum length for stored procedures and functions name is 128.

    Always choose name as meaningful and as much as short.

    Thanks,

    KSB.

    KSB
    -----------------------------
    Thousands of candles can be lit from a single candle, and the life of the candle will not be shortened. Knowledge and happiness never decreases by being shared.” - Buddha

  • Thanks a lot.

    Regards,

    Ramani.

Viewing 3 posts - 1 through 2 (of 2 total)

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