I have a huge SQL server database. The names of the table and the fields in it are a mixture of UPPER and lower cases. Now I want to maintain an uniformity of UPPER cases throughout the database. Is this a viable proposition? Please show me some light on how to go about this....
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Case Problem 1
- Thread starter Warnie
- Start date
-
1
- #2
tlbroadbent
MIS
I personally dislike all UPPER case column and object names. I don't know of any way to enforce that standard. You could upadte the sysobjects table to convert all names to upper case.
Update Sysobjects Set name=upper(name)
where type='u' --type = 'u' is user table Terry L. Broadbent
FAQ183-874 contains tips for posting questions in these forums.
NOTE: Reference to the FAQ is not directed at any individual.
- Status
Similar threads
