sp_rename (SQL Server Compact)
Changes the name of a user table in the current database. Currently, sp_rename support in SQL Server Compact 3.5 is limited to tables.
- [ @objname = ] 'object_name'
Is the name of the user object.
The object_name is nvarchar(776), with no default.
- [ @newname = ] 'new_name'
Is the new name for the user object.
The new_name must be a one-part name and must follow the rules for identifiers. The newname is nvarchar(128), with no default.
- [ @objtype = ] 'object_type'
Is the type of the object that is being renamed. The object_type is nvarchar(13), with a default of NULL.