Does anybody know how to generate upper case DDL via IDA?
Thank in advance.
This topic has been locked.
3 replies Latest Post - 2013-03-06T07:31:18Z by SystemAdmin
Pinned topic Does anybody know how to generate upper case DDL via IDA?
Answered question This question has been answered.
Unanswered question This question has not been answered yet.
Updated on 2013-03-06T07:31:18Z at 2013-03-06T07:31:18Z by SystemAdmin
reital 27000030MC54 PostsACCEPTED ANSWER
Re: Does anybody know how to generate upper case DDL via IDA?2013-03-05T09:42:47Z in response to SystemAdminHello 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.
Re: Does anybody know how to generate upper case DDL via IDA?2013-03-06T06:57:28Z in response to SystemAdminHi 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 .