recreate lawson table

Author
Messages
Ludy
Basic Member
Posts: 21
Basic Member

    Hi,

    Does anyone know if it's possible to recreate a lawson table?  

    If it is, how do we do it?

     

    Thanks,

    Ludy

    John Henley
    Senior Member
    Posts: 3348
    Senior Member
      do you mean you need to recreate it within the database?
      Thanks for using the LawsonGuru.com forums!
      John
      Ludy
      Basic Member
      Posts: 21
      Basic Member
        John, we need to recreate the table itself.
        Xin Li
        Veteran Member
        Posts: 133
        Veteran Member
          If your database is Oracle. you can use bldoraxxddl to recreate table. xx is dependent on which version of Oracle you are using.
          John Henley
          Senior Member
          Posts: 3348
          Senior Member
            Posted By Ludy on 10/06/2016 11:16 AM
            John, we need to recreate the table itself.

            Does the table exist within the Lawson metadata, e.g. dbdef?

            If so, then you would use the bldxxxddl (where xxx is msf, ora, ibm etc.) to create the table in the database.

            Be *VERY* careful with the command, and its options. You can destroy your entire database

            Thanks for using the LawsonGuru.com forums!
            John
            Ludy
            Basic Member
            Posts: 21
            Basic Member
              Thank you, John and Xin for the quick response.
              ---