Reputation
687
Top tag
Next privilege 1,000 Rep.
See votes, expandable usercard
Badges
1 9 27
Impact
~39k people reached

  • 0 posts edited
  • 12 helpful flags
  • 99 votes cast
Jan
30
awarded  Nice Question
Jan
19
accepted How to install Microsoft SQL Server 2014 Standard Edition on trial?
Jan
18
revised How to install Microsoft SQL Server 2014 Standard Edition on trial?
added 148 characters in body
Jan
18
asked How to install Microsoft SQL Server 2014 Standard Edition on trial?
Jan
4
awarded  Famous Question
Dec
23
awarded  Popular Question
Dec
20
awarded  Popular Question
Dec
14
awarded  Popular Question
Dec
8
comment How to name table-variable function unique constraint?
@srutzky Yes, I have already checked it. Just being surprised.
Dec
8
accepted How to name table-variable function unique constraint?
Dec
8
comment How to name table-variable function unique constraint?
Constraints are objects (unlike Indexes) o_O That's something new.
Dec
7
awarded  Informed
Dec
7
comment How to name table-variable function unique constraint?
Yes, you are right it is possible to rename the constraint using sp_rename. That's how I am renaming the other constraints to match the conventions. What I was looking for was a way to define the name when the function is created, but I guess it is a T-SQL limitation.
Dec
7
comment How to name table-variable function unique constraint?
@PeterVandivier Of course it is attach to the function (I will you give you example tomorrow). I will accept the answer once I have access to sql server and perform some additional tests. If the naming of the objects is irrelevant, why the SQL server allows to apply names on objects? I do not want to make a discussion about what is important or why there is a unique constraint applied to the table - this is off-topic for me.
Dec
7
comment How to name table-variable function unique constraint?
@PeterVandivier It's a just a function someone created a long time ago. I am just interested in having unique constraints names in sys.indexes matching a particular naming convention.
Dec
7
comment How to name table-variable function unique constraint?
It is not anything critical. Just following database naming convention. Now, the name is like UQ__fn_name__528885D97FEEF5F1 because it is automatically created by the SQL Server.
Dec
7
asked How to name table-variable function unique constraint?
Nov
30
awarded  Yearling
Nov
19
awarded  Popular Question
Nov
10
awarded  Inquisitive