Monday, 7 November 2011

RENAME TABLE

MS SQL SERVER :
    EXEC SP_RENAME 'OLD_TABLE_NAME' , 'NEW_TABLE_NAME';

ORACLE :
    RENAME 'OLD_TABLE_NAME' TO 'NEW_TABLE_NAME';
DB2 :
    RENAME TABLE 'OLD_TABLE_NAME' TO 'NEW_TABLE_NAME';

No comments:

Post a Comment