æä¹ä¸è½æ¹å¢ ç¨sp_renamedb
sp_renamedb
æ´æ¹æ°æ®åºçå称ã
è¯æ³
sp_renamedb [ @dbname = ] 'old_name' ,
[ @newname = ] 'new_name'
åæ°
[@dbname =] 'old_name'
æ¯æ°æ®åºçå½åå称ãold_name 为 sysname ç±»åï¼æ é»è®¤å¼ã
[@newname =] 'new_name'
æ¯æ°æ®åºçæ°å称ãnew_name å¿
é¡»éµå¾ª
æ è¯ç¬¦è§åãnew_name 为 sysname ç±»åï¼æ é»è®¤å¼ã
è¿å代ç å¼
0ï¼æåï¼æéé¶æ°åï¼å¤±è´¥ï¼
æé
åªæ sysadmin å dbcreator åºå®æå¡å¨è§è²çæåæè½æ§è¡ sp_renamedbã
示ä¾
ä¸ä¾å°æ°æ®åº accounting æ¹å为 financialã
EXEC sp_renamedb 'accounting', 'financial'