oracle drop database

shutdown abort;
startup mount exclusive restrict;
drop database_name;
exit;

Oracle imp/exp file

exp userid/password@SID file=d:\file_name.dmp full=y;

imp userid/password@SID file=d:\file_name.dmp ignore=y tables=(table1);
tables=(table1) is option

MS SQL rename table

ALTER TABLE tablename RENAME TO footable

EXEC sp_rename 'OldTableName', 'NewTableName'

EXEC sp_rename
   @objname = 'TableName.OldColumnName',
   @newname = 'NewColumnName',
   @objtype = 'COLUMN'