Changing Columns to Upper Case

Question

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply

Jeff W SSCertifiable Points: 5207 More actions · Answer 1

I can think of a few of approaches here. Someone else may be able to offer different input.

use the sp_rename procedure for the table name and the columns. Good example in Books Online.
Using the design tool in Enterprise Manager rename the column and table.
With a little juggling of the data, create and populate a new table with the uppercase names. Lots of dependencies to think about and research for this one.

Regardless of how you do it keep in mind this may effect stored procs, keys, etc.

"Keep Your Stick On the Ice" ..Red Green

Rodrigo Acosta SSC-Insane Points: 21261 More actions · Answer 2

SSC-Insane

Points: 21261

April 14, 2004 at 3:20 pm

Why do you need to do that??

jcool SSC Eights! Points: 863 More actions · Answer 3

SELECT LOUD_COLUMN1, LOUD_COLUMN2, LOUD_COLUMN3

FROM LOUD_TABLE

WHERE LOUD_COLUMN1 = "SOME LOUD DATA"

Don't you think this is how code was written, say 20 years ago? And beside lower visual functionality, it's just plain ugly.

PS: No offence intended, just my personal opinion.

msi_99 SSC Veteran Points: 250 More actions · Answer 4

The easier way is to run the update statement against syscolumns table.

select 'update syscolumns set name = upper(name) where object_name(id) like ' + '''' + name + ''''

from sysobjects

where type='U'

order by name

go