How to get a table name from a model in gorm?

Question

Is it possible to get model's table name? I see that it's possible to get it from ModelStruct but I don't know how to do it correctly. I didn't find any initializations for this structure.

user := User{}
tableName := db...

Rosalie

Answer 1

Like this:

tableName := db.NewScope(model).GetModelStruct().TableName(db)

Update: Shorter

tableName := db.NewScope(model).TableName() 

Rosalie

it could be shorter: tableName := db.NewScope(model).TableName() – Leanaleanard

The accepted answer does not work for the library at gorm.io – Delindadelineate

The accepted answer works for v1, for v2 check the answer above. – Kohn

db.NewScope doesnt exists. – Vanwinkle

Answer 2

For Gorm v2, according to https://github.com/go-gorm/gorm/issues/3603, you can do:

stmt := &gorm.Statement{DB: DB}
stmt.Parse(&ColumnStruct2{})
stmt.Schema.Table

Ardithardme

Answer 3

Another method for Gorm v2, without passing a DB object.

type WeatherStation struct{}
s, _ := schema.Parse(&WeatherStation{}, &sync.Map{}, schema.NamingStrategy{})
fmt.Println(s.Table)

Costa

Answer 4

I was facing issue to find table name when trying to setup a scope where two tables can have the same column name. Below snippet works for me.

func(db *gorm.DB) *gorm.DB {
    if db.Statement.Model == nil {
        return db.WithContext(ctx).Where("deleted_at IS NULL")
    }
    model := db.Statement.Model
    db.Statement.Parse(model)
    tableName := db.Statement.Schema.Table
    return db.WithContext(ctx).Where(fmt.Sprintf("%s.deleted_at IS NULL", tableName))
}

Hengelo