Name of Tables and Columns

Hi,
i just migrated an database from oracle to sql server 2005 with the migration tool from microsoft (v3). the migration tool works only with uppercase table and column names, but i need them in lower case. is there a way to modify the names of tables and columns with t-sql to lower case?
Thx
Frank
There is no "alter table ... rename " command.
I have done in following way :
1.In Management Studio select all the tables->right click->Script table as->create to->New query editor window
(all this after I eliminated some scripting setting in Tool->Options->Scripting)
2.Copy all the script
3. Paste in Word ->Format->Change case->lower case : and all the words are lower case-> select all and copy
4.Back in theStudio->paste in a new query window-> select a test db
5. Run that script
(6.Then Import Export wizard etc )|||

yes u can do this using sp_rename system stored procedure . read more in BOL

Madhu

|||

As Madhu indicated, use sp_rename.

EXECUTE sp_rename 'tablename', 'TableName', object

|||Thank you all for help, 'sp_rename' works fine.