Trying to create a SQL function in Visual Studio – nothing happens
I’m creating my first function for a SQL Server database using Visual Studio.
In the DB Explorer, I right-click Function, then Add new scalar function and amend the default script to what I want; it has no error squigglies. The script window has only one button – Update database – I click it – this produces a dialogue saying “User actions, create, [dbo].ValidateEmail] (function)” – I click the update database button.
However, when I right-click Functions in the DB explorer & choose Refresh, nothing is there.
What can I be doing wrong? Thank you for any useful help!