Topic
  • 3 replies
  • Latest Post - ‏2013-03-06T07:31:18Z by SystemAdmin
SystemAdmin
SystemAdmin
374 Posts

Pinned topic Does anybody know how to generate upper case DDL via IDA?

‏2013-03-05T08:01:20Z |
Does anybody know how to generate upper case DDL via IDA?

Thank in advance.

Kennedy
Updated on 2013-03-06T07:31:18Z at 2013-03-06T07:31:18Z by SystemAdmin
  • reital
    reital
    58 Posts

    Re: Does anybody know how to generate upper case DDL via IDA?

    ‏2013-03-05T09:42:47Z  
    Hello Kennedy

    This is no such convert switch but
    The keyword in ddl IDA generated is in Upper case by default. the database structure name if generated in un-quoted styled, it will be created as upper case name in certain database.

    Thanks .
    -Tao
  • SystemAdmin
    SystemAdmin
    374 Posts

    Re: Does anybody know how to generate upper case DDL via IDA?

    ‏2013-03-06T06:57:28Z  
    Hi Kennedy,

    In addition to Tao's replay, there is a pluglet to convert the data object's name to upper case, generate ddl after this case conversion, all words(include the object name) should be in upper case by default.

    You may get the pluglet though attachment, import it into your workspace and then select on database or Physical Data Model, choose Run Pluglet>Register Pluglet, the ChangeNameCase pluglet will be under Customer Pluglets group , run it. Please let me know if you meet a problem .

    regards
    -BM
  • SystemAdmin
    SystemAdmin
    374 Posts

    Re: Does anybody know how to generate upper case DDL via IDA?

    ‏2013-03-06T07:31:18Z  
    By the way, this plulet is not an official one, it is just a reference to help you develop your pluglet:)

    -BM