½â³ýoracleÊý¾Ý¿âÖÐËùÓÐÍâ¼üÔ¼ÊøSQLÓï¾ä
begin
for item in (select * from user_constraints a where a.constraint_type = 'R') loop
execute immediate 'alter table ' || item.table_name || ' disable constraint ' || item.constraint_name;
end loop;
end;
/
Ïà¹ØÎĵµ£º
# MySQL-Front 5.1 (Build 4.2)
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE */;
/*!40101 SET SQL_MODE='STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES */;
/*!40103 SET SQL_NOTES='ON' */;
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS */ ......
»Ö¸´Ä£Ê½ÊÇÊý¾Ý¿âµÄÒ»ÖÖÌØÐÔ,Ëü¿ØÖÆ×ÅÊý¾Ý¿â±¸·ÝºÍ»¹ÔµÄ»ù±¾ÐÐΪ.
sql server ÌṩÁËÈýÖÖ»Ö¸´Ä£Ê½,ËûÃǾö¶¨ÁËÓжàÉÙºÍʲôÑùµÄÊý¾Ý¿ÉÒÔ±»±¸·ÝÏÂÀ´.
1.¼òµ¥»Ö¸´Ä£Ê½
Ö÷ÒªÓ¦ÓÃÓÚСÐÍÊý¾Ý¿âºÍ²»¾³£¸Ä±äµÄÊý¾Ý
2.ÍêÕû»Ö¸´Ä£Ê½
¿ÉÒÔÔÚ×î´ó·¶Î§ÄÚ·ÀÖ¹³öÏÖ¹ÊÕÏʱ¶ªÊ§Êý¾Ý,Ëü°üÀ¨Êý¾Ý¿â±¸·ÝºÍʳÎïÈÕÖ¾±¸·Ý,²¢Ìá¹ ......
1¡¢´´½¨±í£º
create table stud(
sid int,
sname varchar2(50)
)
²¢²åÈëÒ»ÌõÊý¾Ý
&n ......
ÈôÒªÊÕËõÌØ¶¨Êý¾Ý¿âµÄËùÓÐÊý¾ÝºÍÈÕÖ¾Îļþ£¬ÇëÖ´ÐÐ DBCC SHRINKDATABASE ÃüÁî¡£ÈôÒªÒ»´ÎÊÕËõÒ»¸öÌØ¶¨Êý¾Ý¿âÖеÄÒ»¸öÊý¾Ý»òÈÕÖ¾Îļþ£¬ÇëÖ´ÐÐ DBCC SHRINKFILE
ÃüÁî¡£
ÈôÒª²é¿´Êý¾Ý¿âÖе±Ç°µÄ¿ÉÓã¨Î´·ÖÅ䣩¿Õ¼äÁ¿£¬ÇëÔËÐÐ sp_spaceused
¡£
¿ÉÔÚ½ø³ÌÖеÄÈÎÒ»µãÍ£Ö¹ DBCC SHRINKDATABASE ²Ù×÷£¬ÈκÎÒÑÍê³ÉµÄ¹¤×÷¶¼½«±£Áô¡£ ......
<!--
/* Font Definitions */
@font-face
{font-family:SimSun;
panose-1:2 1 6 0 3 1 1 1 1 1;
mso-font-alt:ËÎÌå;
mso-font-charset:134;
mso-generic-font-family:auto;
mso-font-pitch:variable;
mso-font-signature:3 135135232 16 0 262145 0;}
@font-face
{font-family:"Cambria Mat ......