Skip to contents

The prototype contains all tables, all primary and foreign keys, but no data. All tables are truncated and converted to zero-row tibbles, also for remote data models. Column names retain their type. This is useful for performing creation and population of a database in separate steps.

Usage

dm_ptype(dm)

Arguments

dm

A dm object.

Examples

dm_financial() %>%
  dm_ptype()
#> ── Metadata ────────────────────────────────────────────────────────────────────
#> Tables: `accounts`, `cards`, `clients`, `disps`, `districts`, … (9 total)
#> Columns: 57
#> Primary keys: 8
#> Foreign keys: 7

dm_financial() %>%
  dm_ptype() %>%
  dm_nrow()
#>  accounts     cards   clients     disps districts     loans    orders     tkeys 
#>         0         0         0         0         0         0         0         0 
#>     trans 
#>         0