Message
From
22/03/2010 16:07:37
Naomi Nosonovsky
Wisconsin
,
United States
To
22/03/2010 15:52:23
Dmitry Litvak
Massachusetts
,
United States
General information
Forum:
Microsoft SQL Server
Category:
Other
Title:
Re:
Max length of constraint name?
Environment versions
SQL Server:
SQL Server 2005
Miscellaneous
Thread ID:
01456262
Message ID:
01456264
Views:
40
>What is the max length of characters allowed in a name of constraint?
>
>TIA.
128 characters.
Yes, see
http://www.eggheadcafe.com/software/aspnet/32428002/length-of-index-and-const.aspx
and
http://msdn.microsoft.com/en-us/library/ms186939.aspx
sysname is a system-supplied user-defined data type that is functionally equivalent to nvarchar(128), except that it is not nullable. sysname is used to reference database object names.
If it's not broken, fix it until it is.
My Blog
Previous
Next
Reply
Map
View the map of this thread
View the map of this thread starting from this message only
View
View all messages of this thread
View all messages of this thread starting from this message only