how to set the table_name manually instead of generating from class name?

[xdewx]

First Check

• I added a very descriptive title here.
• I used the GitHub search to find a similar question and didn't find it.
• I searched the SQLModel documentation, with the integrated search.
• I already searched in Google "How to X in SQLModel" and didn't find any information.
• I already read and followed all the tutorial in the docs and didn't find an answer.
• I already checked if it is not related to SQLModel but to Pydantic.
• I already checked if it is not related to SQLModel but to SQLAlchemy.

Commit to Help

• I commit to help with one of those options 👆

Example Code

class MyTable(SQLModel, table=True):
    id: int

Description

want the table name to be my_table

Operating System

Linux

Operating System Details

No response

SQLModel Version

0.0.24

Python Version

3.13

Additional Context

No response

[YuriiMotov]

You can set it manually by

class MyTable(SQLModel, table=True):
    __tablename__ = "my_table"
    ...

Or specify function that will be used to generate name (useful if you specify it in base class):

from typing import Optional

from pydantic.alias_generators import to_snake
from sqlalchemy.orm import declared_attr
from sqlmodel import Field, SQLModel, create_engine

class SQLModelBase(SQLModel):
    @declared_attr.directive  # type: ignore[misc]
    @classmethod
    def __tablename__(cls) -> str:
        return to_snake(cls.__name__)

class MyTable(SQLModelBase, table=True):
    ...