Post reply

character limitations on sp name, & function name

  • August 11, 2009 at 11:45 pm

    #134756

    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

  • August 12, 2009 at 12:42 am

    #1037859

    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

  • August 13, 2009 at 5:30 am

    #1038611

    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