Default constraint with synonym or UDF from other database

Question

Is it possible to add default constraint with synonym or UDF from other database?

Create table TestTable ( ID int identity(1,1), SData varchar(100), UserName varchar(100) default [OtherDatabaseName].dbo.fn_Test('value'))

Below is the error message, while I am trying to add default constraint

The name "OtherDatabaseName" is not permitted in this context. Valid expressions are constants, constant expressions, and (in some contexts) variables. Column names are not permitted.

We can add UDF from same database but I want add UDF from other database. Because it is used in multiple databases on same server.

And I do not want to create that UDF in all database and prevent duplicate code.

Please let me know if there is any other/better way. Thank you.

I've been looking for an official reference where it sais you can or cannot do it, but they don't mention this case. But apparantly SQL Server doesn't support it, hence the error message. Have you tried with a synonym as well? — TT.
– TT., Commented Jul 31, 2017 at 19:02

Tab Alleman · Accepted Answer · 2017-07-31 20:07:51Z

1

Please let me know if there is any other/better way.

One other way would be to use a trigger instead of a default.

answered Jul 31, 2017 at 20:07

Tab Alleman

31.8k7 gold badges41 silver badges54 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Default constraint with synonym or UDF from other database

1 Answer 1

Comments

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Related