Create table

CreateTable.fsx

#r "nuget: RepoDb.MySQL"
#load "ConnectionString.fsx"

open MySql.Data.MySqlClient
open RepoDb
open RepoDb.Attributes
open System.Linq

type Create = {
    Table: string
    [<Map("Create Table")>]
    CreateTable: string
}

RepoDb.MySqlBootstrap.Initialize()

let showCreate(db: string, table: string) =
    let connection = new MySqlConnection(ConnectionString.MyConnection)
    let output =
        let cmd = $"show create table {db}.{table}"
        connection.ExecuteQuery<Create>(cmd).First()
    printfn "%s" output.CreateTable

showCreate("alfresco", "alf_child_assoc")