MS SQL Server: Setting default values for fields¶

Let’s say you want certain fields to have their values set automatically when not explicitly passed. You can do this in the following ways:

MS SQL Server defaults: configure default values, using fixed values or simple SQL functions, for columns in the table definition. E.g. an auto-incrementing id, a created_at timestamp, etc.
Role based column presets: set up presets, using session variables or fixed values, that are applied when a row is created/updated with a particular user role. E.g. set a user_id field automatically from a session variable/authorization header.

« previous | next »

Want to contribute or report missing content?

edit this page on github | contributing guidelines | report an issue

Hasura GraphQL engine is open source. See license