---
title: "Column INSERT/UPDATE Defaults — SQLAlchemy 1.4 Documentation"
description: "!https://docs.sqlalchemy.org/en/14/core/defaults.html#server-invoked-ddl-explicit-default-expressions"
date: 2023-07-28
published: true
tags:
  - database
  - python
  - sql
  - sqlalchemy
  - thought
template: link
---


<div class="embed-card embed-card-external">
  <a href="https://docs.sqlalchemy.org/en/14/core/defaults.html#server-invoked-ddl-explicit-default-expressions" class="embed-card-link" target="_blank" rel="noopener noreferrer">
    <div class="embed-card-content">
      <div class="embed-card-title">Column INSERT/UPDATE Defaults
 —
    SQLAlchemy 1.4 Documentation</div>
      <div class="embed-card-meta">docs.sqlalchemy.org</div>
    </div>
  </a>
</div>


sqlalchemy server_defaults end up as defaults in the database when new values are inserted.

``` python
t = Table(
    "test",
    metadata_obj,
    Column("abc", String(20), server_default="abc"),
    Column("created_at", DateTime, server_default=func.sysdate()),
    Column("index_value", Integer, server_default=text("0")),
)

```

``` sql
CREATE TABLE test (
    abc varchar(20) default 'abc',
    created_at datetime default sysdate,
    index_value integer default 0
)
```