Knowledge Draftsman (4/18/2013)
...
i don't think they allow default or check constraints either.
...
Lowell, thanks for the reply.
You can create default constraints, but it doesn't appear that you're allowed to name them. It's the naming part that I'm looking to accomplish.
Actually, right as I was notified of your reply, I was testing out using sp_rename to change the system-generated name to something more standardized. Every indication at this point is that this will work. I just need to work out how to do this on a whole database without hard-coding names.
I think that would introduce concurrency issues unless you get really creative with the naming here. I don't understand why you care what the name of a default constraint is on a table variable. How is that useful?
_______________________________________________________________
Need help? Help us help you.
Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.
Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.
Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/