When I add a default value to a field in my table through VP, when generating the script, it generates it as a string, however I would like it to generate it with a function, as it is an SQL function, just like the GETDATE() function
APP_NAME varchar(300) DEFAULT ‘APP_NAME()’ NOT NULL,
This APP_NAME() should come without the string quotes, as it is a function