Order of CREATE statements for Functions

SqlServer - related issues
Post Reply
behmdk
Posts: 3
Joined: Wed Dec 07, 2016 2:51 pm

Order of CREATE statements for Functions

Post by behmdk » Thu Jan 19, 2017 3:29 pm

I have a table with a check constraint that calls a Scalar-valued function. When I generate the script for my offline project, the table gets created before the function and fails because the function doesn't exist yet. Is there a way to order these statements so that the dependencies do not fail?

Also, is there a way to rename a function in the project tree?

Post Reply