Is there any way to get to the default value in sql server of a field in a template?

Thanks

Could you please elaborate a bit. Possibly an example of what you are trying to achieve.

in a template, I want to get the default value in sql server so I can set the property of the entity to this default value.

For instance I have a table with a field called AmountOfItems. There is an sql default on this field thats 100. I want the entity to set AmountOfItems to 100 when it's created.

You can in an .lpt template read the TARGET field of an entity field (thus the field the entity field is mapped on) which has a property called DefaultValue, that's the value read from the meta-data.

Please check the project inspector plugin in v2 designer and the sdk reference manual.

Thanks!