character limitations on sp name, & function name

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2005 » SQL Server 2005 General Discussion » character limitations on sp name, & function...

character limitations on sp name, & function name

Rate Topic

Display Mode

Topic Options

Author

Message

Chandhini

Posted Tuesday, August 11, 2009 11:45 PM

SSC Rookie

Group: General Forum Members
Last Login: Tuesday, May 10, 2011 12:15 PM
Points: 35, Visits: 210

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

Post #769120

Kari Suresh

Posted Wednesday, August 12, 2009 12:42 AM

SSC Veteran

Group: General Forum Members
Last Login: Tuesday, January 01, 2013 11:12 PM
Points: 248, Visits: 372

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

Post #769133

Chandhini

Posted Thursday, August 13, 2009 5:30 AM

SSC Rookie

Group: General Forum Members
Last Login: Tuesday, May 10, 2011 12:15 PM
Points: 35, Visits: 210

Thanks a lot.

Regards,
Ramani.

Post #770056

« Prev Topic | Next Topic »

Permissions