Are there any statements that can directly export the table creation scripts?

You can use the following custom function to export:

/* @input  dbName: database name
 *         tableName: table name
 *  @output: information from creating the table
 *  @note
 *         
*/
def getDDL(dbName,tableName){
    //table not exist warning
    if(!existsTable(dbName,tableName)){
        return "Please check whether the table exists"
        }
    //Fields and field types
    col1= schema(loadTable(dbName,tableName)).colDefs.name
    col2= schema(loadTable(dbName,tableName)).colDefs.typeString
    col1 = "`"+concat(col1,"`")
    col2 = "["+concat(col2,",")+"]"

    //
    partitionCol = schema(loadTable(dbName,tableName)).partitionColumnName
    partitionCol = "`"+concat(partitionCol,"`")
    //print the information for the creation of table
        print("db = database("+'\"'+database+'\")')
    print("db.createPartitionedTable(table(1:0,"+col1+","+col2+"),`"+tableName+","+partitionCol+")")
}

login(`admin,`123456)
getDDL("dfs://level2","quotes")