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

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
    54 Posts
    ACCEPTED ANSWER

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

    ‏2013-03-05T09:42:47Z  in response to SystemAdmin
    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
    ACCEPTED ANSWER

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

    ‏2013-03-06T06:57:28Z  in response to SystemAdmin
    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
    ACCEPTED ANSWER

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

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

    -BM