Skip to main content
Version: v2.x

MS SQL Server: Setting Default Values for Fields Using MS SQL Server Defaults

Introduction

You can set values of certain fields automatically when not explicitly passed to a fixed value, e.g. true for a boolean field, or output of a simple SQL function, e.g. GETDATE() for a timestamp field, by setting column default values in the table definition.

Note

The MS SQL Server default value is ignored when a value is explicitly set to the field.

Example: Say we have a field created_at in a table article which we want to be set to the current timestamp whenever a new row is added to the table:

Step 1: Modify the table

Edit the created_at field and set its default value as the SQL function GETDATE().

Open the Console and head to Data -> [article] -> Modify.

Click the Edit button next to the created_at field and add GETDATE() as a default value.

Modify the table in the Console
To set an auto-incrementing default value

To set a default value as an auto-incrementing integer you first need to set up a sequence which will be the source of our default value.

Let's say we have a field called roll_number which we would like to be set by default as an auto-incremented integer.

Run the following SQL command to create a new sequence.

CREATE SEQUENCE roll_number_seq AS INT START WITH 0 INCREMENT BY 1;

Now set the default value of the roll_number field as DEFAULT (NEXT VALUE FOR roll_number_seq).

Step 2: Run an insert mutation

Now if you do not pass the created_at field value while running an insert mutation on the article table, its value will be set automatically by MS SQL Server.

GraphiQL
Query Variables
Request Headers
Documentation Explorer
No Schema Available

Also see