# SQL Server Functions Default Values ​​(ERD)

**URL:** <https://forums.visual-paradigm.com/t/sql-server-functions-default-values-erd/18220>\
**Category:** How To\
**Tags:** database, erd\
**Created:** [October 9, 2023, 7:59am UTC](https://forums.visual-paradigm.com/t/sql-server-functions-default-values-erd/18220 "2023-10-09T07:59:54Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![Danilo\_Collado](https://forums.visual-paradigm.com/user_avatar/forums.visual-paradigm.com/danilo_collado/32/6362_2.png) [@Danilo\_Collado](https://forums.visual-paradigm.com/u/Danilo_Collado)\
**Post date:** [October 9, 2023, 7:59am UTC](https://forums.visual-paradigm.com/t/sql-server-functions-default-values-erd/18220/1 "2023-10-09T07:59:54Z")

</div>

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

---

<div class="post-metadata">

**Author:** ![Rain](https://forums.visual-paradigm.com/user_avatar/forums.visual-paradigm.com/rain/32/2309_2.png) [@Rain](https://forums.visual-paradigm.com/u/Rain)\
**Post date:** [October 12, 2023, 9:17am UTC](https://forums.visual-paradigm.com/t/sql-server-functions-default-values-erd/18220/2 "2023-10-12T09:17:46Z")

</div>

I just have a quick test and the function in generated DDL do not have quote on it (see image below). May I know what is the version and build number of VP application you using?

 ![image](https://forums.visual-paradigm.com/uploads/default/original/2X/8/8782f9e72fca7a027e17a3f929eaa1b302e424b5.png)
