no,
sp_rename [ @objname = ] 'object_name' , [ @newname = ] 'new_name' [ , [
@objtype = ] 'object_type' ]
for instance to rename customer.contactTitle to title use:
EXEC sp_rename 'customers.contacttitle', 'title', 'COLUMN'
be aware of stored procedures, views, indexes, etc.
> I'm away from my test servers for the next few days and can't test the
> theory. Does someone know off the top of their heads?
i know nothing off the top of my head: sql server's books-on-line, never
leave home without it.
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
