Home Library Learn Samples Downloads Support Community Forums
MSDN Library
Servers and Enterprise Development
SQL Server
SQL Server Compact
SQL Server Compact 3.5
SQL Server Compact Technical Reference
SQL Reference (SQL Server Compact)
SQL Overview (SQL Server Compact)
+ (Add) (SQL Server Compact)
+ (Positive) (SQL Server Compact)
+ (String Concatenation) (SQL Server Compact)
- (Subtract) (SQL Server Compact)
- (Negative) (SQL Server Compact)
* (Multiply) (SQL Server Compact)
/ (Divide) (SQL Server Compact)
% (Modulo) (SQL Server Compact)
& (Bitwise AND) (SQL Server Compact)
| (Bitwise OR) (SQL Server Compact)
^ (Bitwise Exclusive OR) (SQL Server Compact)
~ (Bitwise NOT) (SQL Server Compact)
= (Equals) (SQL Server Compact)
> (Greater Than) (SQL Server Compact)
< (Less Than) (SQL Server Compact)
>= (Greater Than or Equal To) (SQL Server Compact)
<= (Less Than or Equal To) (SQL Server Compact)
<> (Not Equal To) (SQL Server Compact)
!= (Not Equal To) (SQL Server Compact)
!< (Not Less Than) (SQL Server Compact)
!> (Not Greater Than) (SQL Server Compact)
@@IDENTITY (SQL Server Compact)
@@DBTS (SQL Server Compact)
@@SHOWPLAN (SQL Server Compact)
ABS (SQL Server Compact)
ACOS (SQL Server Compact)
ALL (SQL Server Compact)
ALTER TABLE (SQL Server Compact)
AND (SQL Server Compact)
ASIN (SQL Server Compact)
ATAN (SQL Server Compact)
ATN2 (SQL Server Compact)
AVG (SQL Server Compact)
BETWEEN (SQL Server Compact)
CASE (SQL Server Compact)
CEILING (SQL Server Compact)
CHARINDEX (SQL Server Compact)
COALESCE (SQL Server Compact)
COLLATE (SQL Server Compact)
CAST and CONVERT (SQL Server Compact)
COS (SQL Server Compact)
COT (SQL Server Compact)
COUNT (SQL Server Compact)
CREATE DATABASE (SQL Server Compact)
CREATE INDEX (SQL Server Compact)
CREATE STATISTICS (SQL Server Compact)
CREATE TABLE (SQL Server Compact)
DATALENGTH (SQL Server Compact)
DATEADD (SQL Server Compact)
DATEDIFF (SQL Server Compact)
DATENAME (SQL Server Compact)
DATEPART (SQL Server Compact)
DDL Statements (SQL Server Compact)
DEGREES (SQL Server Compact)
DELETE (SQL Server Compact)
DML Statements (SQL Server Compact)
DROP INDEX (SQL Server Compact)
DROP STATISTICS (SQL Server Compact)
DROP TABLE (SQL Server Compact)
EXISTS (SQL Server Compact)
EXP (SQL Server Compact)
Expressions (SQL Server Compact)
FLOOR (SQL Server Compact)
FROM Clause (SQL Server Compact)
Functions (SQL Server Compact)
GETDATE (SQL Server Compact)
GROUP BY Clause (SQL Server Compact)
HAVING Clause (SQL Server Compact)
Hints (SQL Server Compact)
IDENTITY Property (SQL Server Compact)
IN (SQL Server Compact)
Information Schema (SQL Server Compact)
INSERT (SQL Server Compact)
IS [NOT] NULL (SQL Server Compact)
LEN (SQL Server Compact)
LIKE (SQL Server Compact)
LOG (SQL Server Compact)
LOG10 (SQL Server Compact)
LOWER (SQL Server Compact)
LTRIM (SQL Server Compact)
MAX (SQL Server Compact)
MIN (SQL Server Compact)
NCHAR (SQL Server Compact)
NEWID (SQL Server Compact)
NOT (SQL Server Compact)
Operators (SQL Server Compact)
OR (SQL Server Compact)
ORDER BY Clause (SQL Server Compact)
PATINDEX (SQL Server Compact)
PI (SQL Server Compact)
POWER (SQL Server Compact)
RADIANS (SQL Server Compact)
RAND (SQL Server Compact)
REPLACE (SQL Server Compact)
REPLICATE (SQL Server Compact)
Reserved Words (SQL Server Compact)
ROUND (SQL Server Compact)
RTRIM (SQL Server Compact)
SELECT Statement (SQL Server Compact)
SET IDENTITY INSERT (SQL Server Compact)
SET SHOWPLAN_XML (SQL Server Compact)
SET STATISTICS XML (SQL Server Compact)
SIGN (SQL Server Compact)
SIN (SQL Server Compact)
SOME | ANY (SQL Server Compact)
sp_show_statistics (SQL Server Compact)
sp_rename (SQL Server Compact)
SPACE (SQL Server Compact)
SQRT (SQL Server Compact)
STR (SQL Server Compact)
STUFF (SQL Server Compact)
SUBSTRING (SQL Server Compact)
SUM (SQL Server Compact)
TAN (SQL Server Compact)
timestamp (SQL Server Compact)
TOP (SQL Server Compact)
UNICODE (SQL Server Compact)
UNION (SQL Server Compact)
UPDATE (SQL Server Compact)
UPDATE STATISTICS (SQL Server Compact)
UPPER (SQL Server Compact)
USE (SQL Server Compact)
WHERE Clause (SQL Server Compact)
Expand Minimize
1 out of 2 rated this helpful - Rate this topic

sp_rename (SQL Server Compact)

SQL Server 2008

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.

Copy 

sp_rename [ @objname = ] 'object_name' , [ @newname = ] 'new_name' 
    [ , [ @objtype = ] 'object_type' ]
[ @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.

0 (success) or a nonzero number (failure)

The names of most system objects cannot be changed.

Renaming a table

The following example renames the Order Details table to OrderDetails.

Copy 
sp_rename 'Order Details', 'OrderDetails';
Did you find this helpful?
(1500 characters remaining)
© 2013 Microsoft. All rights reserved.