Change Structure to lowercase

[jadoogar]

I have created a data base with lot of tables but as now Java is case sensitive I want all the structure to be in lowercase only table name, field name
Is there any quick way (programming) to do this?
If so please help
Thanks in advance

 

[nickdel]

now Java is case sensitive

it always has been!

Firstly I would not make everything lowercase as it will be hard to read and is bad practice.

Secondly... why are you not using Stored Procedures??? You should be!

I do not know the consequences of this so I am NOT recommending it but you could look into the sys catalog tables (sysobjects, syscolumns) and amend from here. You can only do this if the server is configured in this way.

Nick

 

[gmmastros]

You'll want to use [!]sp_rename[/!]

You can rename tables and columns. For more information, look it up in Books On Line.



-George

"The great things about standards is that there are so many to choose from." - Fortune Cookie Wisdom