数据库差异比较

数据库表名列名索引名索引列触发器函数名过程名用户名约束名规则名注释块终结分隔符行注释引号续行终结符属主前缀非法字符大小写字符函数Oracle7/8/9303030323030303030Informix7*1818181618181818Sybase11.x303030163012830303030/* */go,--'MSSQL2k12812812816128128128128128/* *//,--';有 +-*/!=&<>'()\".均可ascii()chr()concat()initcap()instr()instrb()length()lengthb()lower()lpad()ltrim()nls_initcap()nls_lower()nls_upper()nlssort()replace()rpad()rtrim()soundex()substr()substrb()translate()upper()/,--\";有有 +-*/!=<>'()&~#{[|^@]?° +-*/!=<>'()\".μ,?;.:?󰁣\"均可均可length()ascii()char()charindex()char_length()difference()lower()ltrim()patindex()replicate()reverse()right()rtrim()soundex()space()str()stuff()substring()textptr()textvalid()upper()提交commitcommitcommit转换函数chartorowid()convert()hextoraw()rawtohex()rowidtochar()trim()convert()hextoint()inttohex()to_char()to_date()to_label()to_multi_byte()to_number()to_single_byte()数学函数abs()acos()asin()atan()atan2()ceil()cos()cosh()exp()floor()ln()log()mod()power()round()sign()sin()sinh()sqrt()tan()tanh()trunc()abs()acos()asin()atan()atan2()cos()exp()hex()logn()log10()mod()pow()round()sin()sqrt()tan()trunc()abs()acos()asin()atan()atn2()ceiling()cos()cot()degrees()exp()floor()log()log10()pi()power()radians()rand()round()sign()sin()sqrt()tan()分组函数avg()count()glb()lub()max()min()stddev()sum()variance()avg()count()max()min()sum()avg()count()max()min()sum()日期函数add_months()last_day()currentdate()dateadd()datediff()months_between()new_time()next_day()round()sysdatetrunc()day()extend()mdy()month()todayunitsweekday()year()datename()datepart()getdate()daydaydaydowgethouhouminminmonmonmonnowquasecsec

其它函数bfilename()dbinfo()currvalrowiddecode()userdump()empty_blob()empty_clob()greatest()least()levelnls_charset_decl_len()nls_charset_id()nls_charset_name()nvl()nextvalrowidrownumuiduseruserenv()vsize()col_length()col_name()curunreservedpgs()data_pgs()datalength()db_id()db_name()host_id()host_name()index_col()isnull()lct_admin()object_id()object_name()proc_role()reserved_pgs()rowcnt()show_role()suser_id()suser_name()used_pgs()tsequal()useruser_id()user_name()valid_name()coalesce()col_length()col_name()columnproperty()cursor_status()datalength()databaseproperty()db_id()db_name()file_id()file_name()filegroup_id()filegroup_name()getainsinull()getchecksum()host_id()host_name()ident_incr()ident_seed()index_col()indexproperty()is_member()is_srvrolemember()isdate()isnull()isnumeric()newid()nullif()object_id()object_name()objectproperty()parsename()permissions()stats_date()suser_id()suser_name()suser_sid()suser_sname()trigger_nestlevel()typeproperty()user_id()user_name()操作符=!=^=<>><>=<=*==*notinnot inbetweennot betweenexistsnot existslikenot likeisis not= any!= any> any< any>= any<= any= all!= all> all< all>= all<= all=!=<>><>=<=*==*notinnot inbetweennot betweenexistsnot existslikenot likematchesnot matchesisis not= any!= any> any< any>= any<= any= all!= all> all< all>= all<= all=!=<>>!>=<=*==*notinnot inbetweennot betweenexistsnot existslikenot likeisis not= any<> any> any< any>= any<= any= all<> all> all< all>= all<= all=!=<>>!>=<=*==*notinnot inbetweennot betweenexistsnot existslikenot likeisis not= any<> any> any< any>= any<= any= all<> all> all< all>= all<= all保留名NULLSYSDATEUSERCURRENTNULLTODAYusernullgetdate()user_id()SITENAMEDBSERVERNAMEuser_name()db_id()db_name()host_id()host_name()suser_id()suser_name()show_role()保留字ACCESSADDALLALTERANDANYASASCAUDITBETWEENBYCHARCHECKCLUSTERCOLUMNCOMMENTCOMPRESSCONNECTCREATECURRENTDATEDECIMALDEFAULTDELETEDESCDISTINCTDROPELSEEXCLUSIVEEXISTSFILEFLOATFORFROMGRANTGROUPHAVINGIDENTIFIEDIMMEDIATEININCREMENTINDEXINITIALINSERTADDAFTERALLALL_ROWSALTERANDANSIANYAPPENDASASCATATTACHAUDITAUTHORIZATIONAVGBEFOREBEGINBETWEENBOTHBUFFEREDBYBYTECALLCASCADECASECHARCHAR_LENGTHCHARACTERCHARACTER_LENGTHCHECKCLOSECLUSTERCLUSTERSIZECOBOLCOLUMNCOMMITCOMMITTEDCONNECTCONSTRAINTCONSTRAINTSCONTINUECOUNTCRCOLSACTIVATIONADDALLALTERANDANYARITH_OVERFLOWASASCATAUTHORIZATIONAVGBEGINBETWEENBREAKBROWSEBULKBYCASCADECHAR_CONVERTCHECKCHECKPOINTCLOSECLUSTEREDCOMMITCOMPUTECONFIRMCONNECTCONSTRAINTCONSUMERSCONTINUECONTROLROWCONVERTCOUNTCREATECURRENTCURSORDATABASEDBCCDEALLOCATEDECLAREDEFAULTDELETEDESCADDALLALTERANDANYASASCAUTHORIZATIONBACKUPBEGINBETWEENBREAKBROWSEBULKBYCASCADECASECHECKCHECKPOINTCLOSECLUSTEREDCOALESCECOLLATECOLUMNCOMMITCOMPUTECONSTRAINTCONTAINSCONTAINSTABLECONTINUECONVERTCREATECROSSCURRENTCURRENT_DATECURRENT_TIMECURRENT_TIMESTAMPCURRENT_USERCURSORDATABASEDBCCDEALLOCATEDECLAREDEFAULTINTEGERINTERSECTINTOISLEVELLIKELOCKLONGMAXEXTENTSMINUSMLSLABELMODEMODIFYNOAUDITNOCOMPRESSNOTNOWAITNULLNUMBEROFOFFLINEONONLINEOPTIONORORDERPCTFREEPRIORPRIVILEGESPUBLICRAWRENAMERESOURCEREVOKEROWROWIDROWNUMROWSSELECTSESSIONSETSHARESIZESMALLINTSTARTSUCCESSFULSYNONYMSYSDATETABLETHENTOTRIGGERUIDUNIONUNIQUEUPDATEUSERVALIDATEVALUESVARCHARCREATECURRENTCURSORDATABASEDATASKIPDATEDATETIMEDAYDBADBPASSWORDDEBUGDECDECIMALDECLAREDECODEDEFAULTDEFERREDDEFINEDELETEDESCDETACHDIRTYDISABLEDDISTINCTDISTRIBUTIONSDOCUMENTDOUBLEDROPEACHELIFELSEENABLEDENDERRORESCAPEEXCEPTIONEXCLUSIVEEXECEXECUTEEXISTSEXITEXPLAINEXPRESSIONEXTENDEXTENTFETCHFILEFILLFACTORFILTERINGFIRST_ROWSFLOATFORFOREACHFOREIGNFORTRANFOUNDFRACTIONFRAGMENTFROMGLOBALDISKDISTINCTDOUBLEDUMMYDUMPELSEENDENDTRANERRLVLERRORDATAERROREXITESCAPEEXCEPTEXCLUSIVEEXECEXECUTEEXISTSEXITEXTERNALFETCHFILLFACTORFORFOREIGNFROMGOTOGRANTGROUPHAVINGHOLDLOCKIDENTITY_INSERTIDENTITY_STARTIFININDEXINSERTINTERSECTINTOISISOLATIONKEYKILLLEVELLIKELINENOLINENOLOADMAXMAX_ROWS_PER_PAGEMEMBERSHIPMINMIRRORMIRROREXITNATIONALNOHOLDLOCKNONCLUSTEREDNOTNULLNUMERIC_TRANSACTIONOFOFFDELETEDENYDESCDISKDISTINCTDISTRIBUTEDDOUBLEDROPDUMMYDUMPELSEENDERRLVLESCAPEEXCEPTEXECEXECUTEEXISTSEXITFETCHFILEFILLFACTORFORFOREIGNFREETEXTFREETEXTTABLEFROMFULLFUNCTIONGOTOGRANTGROUPHAVINGHOLDLOCKIDENTITYIDENTITY_INSERTIDENTITYCOLIFININDEXINNERINSERTINTERSECTINTOISJOINKEYKILLLEFTLIKELINENOLOADNATIONALNOCHECKNONCLUSTEREDNOTNULLNULLIFOFOFFVARCHAR2VIEWWHENEVERWHEREWITHGOGOTOGRANTGROUPHAVINGHIGHHOLDHOURIFIMMEDIATEININDEXINDEXESINDICATORINITINITCAPINSERTINTINTEGERINTERVALINTOISISOLATIONKEYLABELEQLABELGELABELGLBLABELGTLABELLELABELLTLABELLUBLABELTOSTRINGLANGUAGELEADINGLETLEVELLIKELISTINGLOCKLOGLOWLOWERMATCHESMAXMEDIANMEDIUMMEMORY_RESIDENTMINMINUTEMODEMODIFYMODULEMONEYMONTHMOUNTINGNCHARNEWNEXTNONON_RESIDENTOFFSETSONONCEONLINEONLYOPENOPTIONORORDEROVERPARTITIONPASSWDPERMPERMANENTPLANPRECISIONPREPAREPRIMARYPRINTPRIVILEGESPROCPROCEDUREPROCESSEXITPROXYPUBLICRAISERRORREADREADTEXTRECONFIGUREREFERENCESREPLACERETURNREVOKEROLEROLLBACKROWCOUNTROWSRULESAVESCHEMASELECTSESSIONSETSETUSERSHAREDSHUTDOWNSOMESTATISTICSSTRIPESUMSYB_IDENTITYSYB_RESTREETABLETEMPTEMPORARYTEXTSIZETOTRANTRANSACTIONTRIGGEROFFSETSONOPENOPENDATASOURCEOPENQUERYOPENROWSETOPENXMLOPTIONORORDEROUTEROVERPERCENTPLANPRECISIONPRIMARYPRINTPROCPROCEDUREPUBLICRAISERRORREADREADTEXTRECONFIGUREREFERENCESREPLICATIONRESTORERESTRICTRETURNREVOKERIGHTROLLBACKROWCOUNTROWGUIDCOLRULESAVESCHEMASELECTSESSION_USERSETSETUSERSHUTDOWNSOMESTATISTICSSYSTEM_USERTABLETEXTSIZETHENTOTOPTRANTRANSACTIONTRIGGERTRUNCATETSEQUALUNIONUNIQUEUPDATEUPDATETEXTUSENONENOTNULLNUMERICNVARCHARNVLOCTET_LENGTHOFOFFOLDONONLYOPENOPTICALOPTIMIZATIONOPTIONORORDEROUTERPAGEPASCALPDQPRIORITYPLIPRECISIONPRIMARYPRIVATEPRIVILEGESPROCEDUREPUBLICRAISERANGEREADREALRECOVERREFERENCESREFERENCINGRELEASEREMAINDERRENAMEREPEATABLEREPLICATIONRESERVERESOLUTIONRESOURCERESTRICTRESUMERETURNRETURNINGRETURNSREVOKEROBINROLEROLLBACKROLLFORWARDROUNDROWROWIDSROWSSCHEMASECONDTRUNCATETSEQUALUNIONUNIQUEUNPARTITIONUPDATEUSEUSERUSER_OPTIONUSINGVALUESVARYINGVIEWWAITFORWHEREWHILEWITHWORKWRITETEXTUSERVALUESVARYINGVIEWWAITFORWHENWHEREWHILEWITHWRITETEXTSECTIONSELECTSERIALSERIALIZABLESESSIONSETSHARESIZESKALLSKINHIBITSKSHOWSMALLFLOATSMALLINTSOMESQLSQLCODESQLERRORSTABILITYSTARTSTATISTICSSTDEVSTEPSTOPSTRINGTOLABELSUBSTRSUBSTRINGSUMSYNONYMSYSTEMTABLETEMPTEXTTHENTIMEOUTTOTRACETRAILINGTRANSACTIONTRIGGERTRIGGERSTRIMUNCOMMITTEDUNIONUNIQUEUNITSUNLOCKUPDATEUPPERUSINGVALUESVARCHARVARIANCEVARYINGVIEWVIOLATIONSWAITWHENWHENEVERWHEREWHILEWITHWITHOUTWORKWRITEYEARMSSQL7.x12812812816128128128128128AC2k1030DB2UDB712830181618181283018MYSQL3.23/3.221630/* */go,';,#';无 +*/!=<>'()\".均可ascii()byte_length()byte_substr()char()charindex()difference()insertstr()lcase()left()length()locate()ltrim()patindex()repeat()right()rtrim()similar()soundex()space()string()substr()textptr()trim()ucase()/,--有 +-*/!=<>'()\".均可ascii()char()charindex()difference()left()len()lower()ltrim()nchar()patindex()replace()quotename()replicate()reverse()right()rtrim()soundex()space()str()stuff()substring()textptr()textvalid()unicode()upper();有 +-*/!=<>'()\".均可char()length()substr()value()blob()commitcommitcommitcast()convert()cast()convert()hextoint()inttohex()string()decimal()digits()double()float()hex()integer()timestamp()vargraphic()abs()acos()asin()atan()atn2()ceiling()cos()cot()degrees()exp()floor()log()log10()pi()power()radians()rand()round()sign()sin()square()sqrt()tan()abs()acos()asin()atan()atan2()ceiling()cos()cot()degrees()exp()floor()log()log10()mod()pi(*)power()radians()rand()remainder()round()sign()sin()sqrt()tan()truncate()avg()count()list()max()min()sum()avg()count()count_big()max()min()sum()avg()count()max()min()sum()var()varp()stdev()stdevp()dateadd()datediff()current datecurrent timecurrent datecurrent timedatename()datepart()getdate()current timestampdate()dateadd()datediff()dateformat()datename()datepart()datetime()day()dayname()days()dow()getdate()hour()hours()minute()minutes()month()monthname()months()now(*)quarter()second()seconds()today(*)weeks()year()years()ymd()current timestampcurrent timezonedate()day()days()hour()microsecond()minute()month()posstr()second()time()year()index_col()indexproperty()is_member()is_srvrolemember()isdate()isnull()isnumeric()newid()nullif()object_id()object_name()objectproperty()parsename()permissions()stats_date()suser_id()suser_name()suser_sid()suser_sname()trigger_nestlevel()typeproperty()user_id()user_name()argn()coalesce()coalesce()event_mon_state()connection_property()generate_unique()datalength()nullif()db_id()raise_error()db_name()table_name()db_property()table_schema()estimate()userestimate_source()experience_estimate()ifnull()index_estimate()isnull()next_connection()next_database()number(*)plan()property()property_name()property_number()property_description()sqlcodesqlstatetraceback(*)user=!=<>>!>=<=*==*notinnot inbetweennot betweenexistsnot existslikenot likeisis not= any<> any> any< any>= any<= any= all<> all> all< all>= all<= all=!=~=<>>!>=<=*==*notinnot inbetweennot betweenexistsnot existslikenot likeisis not= any!= any> any!> any< any!< any>= any<= any= all!= all> all!> all< all!< all>= all<= all=<>><>=<=*==*notinnot inbetweennot betweenexistsnot existslikenot likeisis not= any<> any> any< any>= any<= any= all<> all> all< all>= all<= allusernullcurrent_usersession_userUSERNULLNULLUSERCURRENT DATECURRENT DEGREEsystem_usercurrent_timestampgetdate()user_id()user_name()db_id()db_name()host_id()host_name()suser_id()suser_name()CURRENT PACKAGESETCURRENT RULESCURRENT SERVERCURRENT SQLIDCURRENT TIMECURRENT TIMESTAMPCURRENT TIMEZONEADDALLALTERANDANYASASCAUTHORIZATIONAVGBACKUPBEGINBETWEENBREAKBROWSEBULKBYCASCADECASECHECKCHECKPOINTCLOSECLUSTEREDCOALESCECOLUMNCOMMITCOMMITTEDCOMPUTECONFIRMCONSTRAINTCONTAINSCONTAINSTABLECONTINUECONTROLROWCONVERTCOUNTCREATECROSSCURRENTCURRENT_DATECURRENT_TIMECURRENT_TIMESTAMPCURRENT_USERCURSORDATABASEADDALLALTERANDANYASASCBETWEENBYCHARCHECKCONNECTCREATECURRENTDATEDECIMALDEFAULTDELETEDESCDISTINCTDROPELSEFLOATFORFROMGRANTGROUPHAVINGIMMEDIATEININSERTINTEGERINTERSECTINTOISLEVELLIKENOTNULLOFONOPTIONORORDERACQUIREADDAFTERALIASALLALLOCATEALLOWALTERANDANYASASCASUTIMEAUDITAUTHORIZATIONAUXAUXILIARYAVGBEFOREBEGINBETWEENBINARYBUFFERPOOLBYCALLCALLEDCAPTURECASCADEDCASECASTCCSIDCHARCHARACTERCHECKCLOSECLUSTERCOLLECTIONCOLLIDCOLUMNCOMMENTCOMMITCONCATCONDITIONCONNECTDBCCDEALLOCATEDECLAREDEFAULTDELETEDENYDESCDISKDISTINCTDISTRIBUTEDDOUBLEDROPDUMMYDUMPELSEENDERRLVLERROREXITESCAPEEXCEPTEXECEXECUTEEXISTSEXITFETCHFILEFILLFACTORFLOPPYFORFOREIGNFREETEXTFREETEXTTABLEFROMFULLGOTOGRANTGROUPHAVINGHOLDLOCKIDENTITYIDENTITY_INSERTIDENTITYCOLIFININDEXINNERINSERTINTERSECTINTOISISOLATIONJOINKEYKILLLEFTLEVELLIKELINENOLOADMAXPRIORPRIVILEGESPUBLICREVOKEROWSSELECTSESSIONSETSIZESMALLINTTABLETHENTOUNIONUNIQUEUPDATEUSERVALUESVARCHARVIEWWHENEVERWITHCONNECTIONCONSTRAINTCONTAINSCONTINUECOUNTCOUNT_BIGCREATECROSSCURRENTCURRENT_DATECURRENT_LC_PATHCURRENT_PATHCURRENT_SERVERCURRENT_TIMECURRENT_TIMESTAMPCURRENT_TIMEZONECURRENT_USERCURSORDATADATABASEDATEDAYDAYSDB2GENERALDB2SQLDBADBINFODBSPACEDECLAREDEFAULTDELETEDESCDESCRIPTORDETERMINISTICDISALLOWDISCONNECTDISTINCTDODOUBLEDROPDSSIZEDYNAMICEDITPROCELSEELSEIFENDEND-EXECERASEESCAPEEXCEPTEXCEPTIONEXCLUSIVEEXECUTEEXISTSEXITEXPLAINEXTERNALFENCEDFETCHFIELDPROCMINMIRROREXITNATIONALNOCHECKNONCLUSTEREDNOTNULLNULLIFOFOFFOFFSETSONONCEONLYOPENOPENDATASOURCEOPENQUERYOPENROWSETOPTIONORORDEROUTEROVERPERCENTPERMPERMANENTPIPEPLANPRECISIONPREPAREPRIMARYPRINTPRIVILEGESPROCPROCEDUREPROCESSEXITPUBLICRAISERRORREADREADTEXTRECONFIGUREREFERENCESREPEATABLEREPLICATIONRESTORERESTRICTRETURNREVOKERIGHTROLLBACKROWCOUNTROWGUIDCOLRULESAVESCHEMASELECTSERIALIZABLESESSION_USERSETSETUSERFILEFINALFORFOREIGNFREEFROMFULLFUNCTIONGENERALGENERATEDGOGOTOGRANTGRAPHICGROUPHANDLERHAVINGHOURHOURSIDENTIFIEDIFIMMEDIATEININDEXINDICATORINNERINOUTINSENSITIVEINSERTINTEGRITYINTERSECTINTOISISOBIDISOLATIONJAVAJOINKEYLABELLANGUAGELC_CTYPELEAVELEFTLIKELINKTYPELOCALLOCALELOCATORLOCATORSLOCKLOCKSIZELONGLOOPMAXMICROSECONDMICROSECONDSMINMINUTEMINUTESMODESHUTDOWNSOMESTATISTICSSUMSYSTEM_USERTABLETAPETEMPTEMPORARYTEXTSIZETHENTOTOPTRANTRANSACTIONTRIGGERTRUNCATETSEQUALUNCOMMITTEDUNIONUNIQUEUPDATEUPDATETEXTUSEUSERVALUESVARYINGVIEWWAITFORWHENWHEREWHILEWITHWORKWRITETEXTMODIFIESMONTHMONTHSNAMENAMEDNHEADERNONODENAMENODENUMBERNOTNULLNULLSNUMPARTSOBIDOFONONLYOPENOPTIMIZATIONOPTIMIZEOPTIONORORDEROUTOUTERPACKAGEPAGEPAGESPARAMETERPARTPARTITIONPATHPCTFREEPCTINDEXPIECESIZEPLANPOSITIONPRECISIONPREPAREPRIMARYPRIQTYPRIVATEPRIVILEGESPROCEDUREPROGRAMPSIDPUBLICQUERYNOREADREADSRECOVERYREFERENCESRELEASERENAMEREPEATRESETRESOURCERESTRICTRESULTRETURNRETURNSREVOKERIGHTROLLBACKROWROWSRRNRUNSCHEDULESCHEMASCRATCHPADSECONDSECONDSSECQTYSECURITYSELECTSETSHARESIMPLESOMESOURCESPECIFICSQLSTANDARDSTATICSTATISTICSSTAYSTOGROUPSTORESSTORPOOLSTYLESUBPAGESSUBSTRINGSUMSYNONYMTABLETABLESPACETHENTOTRANSACTIONTRIGGERTRIMTYPEUNDOUNIONUNIQUEUNTILUPDATEUSAGEUSERUSINGVALIDPROCVALUESVARIABLEVARIANTVCATVIEWVOLUMESWHENWHEREWHILEWITHWLMWORKWRITEYEARYEARS