To rename a table
Exec sp_Rename 'schema.original_table_name','new_table_name','object'
Go
To rename a field
Exec sp_Rename 'schema.table_name.original_field_name','new_field_name','column'
Go
Note: The rule requiring [brackets] around partially invalid names (i.e. - dbo.[1_Table_Name]) should be used in the original name section...
[font="Arial"]“Any fool can know. The point is to understand.”
- Albert Einstein
"DOH!"
- Homer Simpson[/font]