Skip to content

Instantly share code, notes, and snippets.

@kmatt
Created February 21, 2011 20:39
Show Gist options
  • Select an option

  • Save kmatt/837674 to your computer and use it in GitHub Desktop.

Select an option

Save kmatt/837674 to your computer and use it in GitHub Desktop.
SQL highlighting for PyCharm (and probably RubyMine, IntelliJ IDEA), with T-SQL specifics
<?xml version="1.0" encoding="UTF-8"?>
<filetype binary="false" default_extension="" description="SQL" name="SQL">
<highlighting>
<options>
<option name="LINE_COMMENT" value="--" />
<option name="COMMENT_START" value="/*" />
<option name="COMMENT_END" value="*/" />
<option name="HEX_PREFIX" value="" />
<option name="NUM_POSTFIXES" value="" />
<option name="HAS_BRACKETS" value="true" />
<option name="HAS_BRACES" value="false" />
<option name="HAS_PARENS" value="true" />
<option name="HAS_STRING_ESCAPES" value="false" />
</options>
<keywords ignore_case="true">
<keyword name="add" />
<keyword name="all" />
<keyword name="alter" />
<keyword name="and" />
<keyword name="any" />
<keyword name="as" />
<keyword name="asc" />
<keyword name="authorization" />
<keyword name="avg" />
<keyword name="backup" />
<keyword name="begin" />
<keyword name="between" />
<keyword name="break" />
<keyword name="browse" />
<keyword name="bulk" />
<keyword name="by" />
<keyword name="cascade" />
<keyword name="case" />
<keyword name="check" />
<keyword name="checkpoint" />
<keyword name="close" />
<keyword name="clustered" />
<keyword name="coalesce" />
<keyword name="column" />
<keyword name="commit" />
<keyword name="committed" />
<keyword name="compute" />
<keyword name="confirm" />
<keyword name="constraint" />
<keyword name="contains" />
<keyword name="containstable" />
<keyword name="continue" />
<keyword name="controlrow" />
<keyword name="convert" />
<keyword name="count" />
<keyword name="create" />
<keyword name="cross" />
<keyword name="current" />
<keyword name="current_date" />
<keyword name="current_time" />
<keyword name="current_timestamp" />
<keyword name="current_user" />
<keyword name="cursor" />
<keyword name="database" />
<keyword name="dbcc" />
<keyword name="deallocate" />
<keyword name="declare" />
<keyword name="default" />
<keyword name="delete" />
<keyword name="deny" />
<keyword name="desc" />
<keyword name="disk" />
<keyword name="distinct" />
<keyword name="distributed" />
<keyword name="double" />
<keyword name="drop" />
<keyword name="dummy" />
<keyword name="dump" />
<keyword name="else" />
<keyword name="end" />
<keyword name="errlvl" />
<keyword name="errorexit" />
<keyword name="escape" />
<keyword name="except" />
<keyword name="exec" />
<keyword name="execute" />
<keyword name="exists" />
<keyword name="exit" />
<keyword name="fetch" />
<keyword name="file" />
<keyword name="fillfactor" />
<keyword name="floppy" />
<keyword name="for" />
<keyword name="foreign" />
<keyword name="freetext" />
<keyword name="freetexttable" />
<keyword name="from" />
<keyword name="full" />
<keyword name="go" />
<keyword name="goto" />
<keyword name="grant" />
<keyword name="group" />
<keyword name="having" />
<keyword name="holdlock" />
<keyword name="identity" />
<keyword name="identity_insert" />
<keyword name="identitycol" />
<keyword name="if" />
<keyword name="in" />
<keyword name="index" />
<keyword name="inner" />
<keyword name="insert" />
<keyword name="intersect" />
<keyword name="into" />
<keyword name="is" />
<keyword name="isolation" />
<keyword name="join" />
<keyword name="key" />
<keyword name="kill" />
<keyword name="left" />
<keyword name="level" />
<keyword name="like" />
<keyword name="lineno" />
<keyword name="load" />
<keyword name="max" />
<keyword name="min" />
<keyword name="mirrorexit" />
<keyword name="national" />
<keyword name="nocheck" />
<keyword name="nonclustered" />
<keyword name="not" />
<keyword name="null" />
<keyword name="nullif" />
<keyword name="of" />
<keyword name="off" />
<keyword name="offsets" />
<keyword name="on" />
<keyword name="once" />
<keyword name="only" />
<keyword name="open" />
<keyword name="opendatasource" />
<keyword name="openquery" />
<keyword name="openrowset" />
<keyword name="option" />
<keyword name="or" />
<keyword name="order" />
<keyword name="outer" />
<keyword name="over" />
<keyword name="percent" />
<keyword name="perm" />
<keyword name="permanent" />
<keyword name="pipe" />
<keyword name="plan" />
<keyword name="precision" />
<keyword name="prepare" />
<keyword name="primary" />
<keyword name="print" />
<keyword name="privileges" />
<keyword name="proc" />
<keyword name="procedure" />
<keyword name="processexit" />
<keyword name="public" />
<keyword name="raiserror" />
<keyword name="read" />
<keyword name="readtext" />
<keyword name="reconfigure" />
<keyword name="references" />
<keyword name="repeatable" />
<keyword name="replication" />
<keyword name="restore" />
<keyword name="restrict" />
<keyword name="return" />
<keyword name="revoke" />
<keyword name="right" />
<keyword name="rollback" />
<keyword name="rowcount" />
<keyword name="rowguidcol" />
<keyword name="rule" />
<keyword name="save" />
<keyword name="schema" />
<keyword name="select" />
<keyword name="serializable" />
<keyword name="session_user" />
<keyword name="set" />
<keyword name="setuser" />
<keyword name="shutdown" />
<keyword name="some" />
<keyword name="statistics" />
<keyword name="sum" />
<keyword name="system_user" />
<keyword name="table" />
<keyword name="tape" />
<keyword name="temp" />
<keyword name="temporary" />
<keyword name="textsize" />
<keyword name="then" />
<keyword name="to" />
<keyword name="top" />
<keyword name="tran" />
<keyword name="transaction" />
<keyword name="trigger" />
<keyword name="truncate" />
<keyword name="tsequal" />
<keyword name="uncommitted" />
<keyword name="union" />
<keyword name="unique" />
<keyword name="update" />
<keyword name="updatetext" />
<keyword name="use" />
<keyword name="user" />
<keyword name="values" />
<keyword name="varying" />
<keyword name="view" />
<keyword name="waitfor" />
<keyword name="when" />
<keyword name="where" />
<keyword name="while" />
<keyword name="with" />
<keyword name="work" />
<keyword name="writetext" />
</keywords>
<keywords2 ignore_case="true">
<keyword name="binary" />
<keyword name="bit" />
<keyword name="char" />
<keyword name="character" />
<keyword name="datetime" />
<keyword name="dec" />
<keyword name="decimal" />
<keyword name="float" />
<keyword name="image" />
<keyword name="int" />
<keyword name="integer" />
<keyword name="money" />
<keyword name="nchar" />
<keyword name="ntext" />
<keyword name="numeric" />
<keyword name="nvarchar" />
<keyword name="real" />
<keyword name="smalldatetime" />
<keyword name="smallint" />
<keyword name="smallmoney" />
<keyword name="text" />
<keyword name="timestamp" />
<keyword name="tinyint" />
<keyword name="uniqueidentifier" />
<keyword name="varbinary" />
<keyword name="varchar" />
</keywords2>
<keywords3>
<keyword name="SYSREMOTE_CATALOGS" />
<keyword name="SYSREMOTE_COLUMNS" />
<keyword name="SYSREMOTE_COLUMN_PRIVILEGES" />
<keyword name="SYSREMOTE_FOREIGN_KEYS" />
<keyword name="SYSREMOTE_INDEXES" />
<keyword name="SYSREMOTE_PRIMARY_KEYS" />
<keyword name="SYSREMOTE_PROVIDER_TYPES" />
<keyword name="SYSREMOTE_SCHEMATA" />
<keyword name="SYSREMOTE_STATISTICS" />
<keyword name="SYSREMOTE_TABLES" />
<keyword name="SYSREMOTE_TABLE_PRIVILEGES" />
<keyword name="SYSREMOTE_VIEWS" />
<keyword name="sp_GetMBCSCharLen" />
<keyword name="sp_IsMBCSLeadByte" />
<keyword name="sp_MSIfExistsRemoteLogin" />
<keyword name="sp_MSSQLDMO70_version" />
<keyword name="sp_MSSQLOLE65_version" />
<keyword name="sp_MSSQLOLE_version" />
<keyword name="sp_MS_marksystemobject" />
<keyword name="sp_MS_replication_installed" />
<keyword name="sp_MS_upd_sysobj_category" />
<keyword name="sp_MSactivate_auto_sub" />
<keyword name="sp_MSadd_distributor_alerts_and_responses" />
<keyword name="sp_MSadd_mergereplcommand" />
<keyword name="sp_MSadd_repl_job" />
<keyword name="sp_MSaddanonymousreplica" />
<keyword name="sp_MSaddarticletocontents" />
<keyword name="sp_MSaddexecarticle" />
<keyword name="sp_MSaddguidcolumn" />
<keyword name="sp_MSaddguidindex" />
<keyword name="sp_MSaddinitialarticle" />
<keyword name="sp_MSaddinitialpublication" />
<keyword name="sp_MSaddinitialsubscription" />
<keyword name="sp_MSaddlogin_implicit_ntlogin" />
<keyword name="sp_MSaddmergepub_snapshot" />
<keyword name="sp_MSaddmergetriggers" />
<keyword name="sp_MSaddpub_snapshot" />
<keyword name="sp_MSaddpubtocontents" />
<keyword name="sp_MSaddupdatetrigger" />
<keyword name="sp_MSadduser_implicit_ntlogin" />
<keyword name="sp_MSarticlecleanup" />
<keyword name="sp_MSarticletextcol" />
<keyword name="sp_MSbelongs" />
<keyword name="sp_MSchange_priority" />
<keyword name="sp_MSchangearticleresolver" />
<keyword name="sp_MScheck_agent_instance" />
<keyword name="sp_MScheck_uid_owns_anything" />
<keyword name="sp_MScheckatpublisher" />
<keyword name="sp_MScheckexistsgeneration" />
<keyword name="sp_MScheckmetadatamatch" />
<keyword name="sp_MScleanup_subscription" />
<keyword name="sp_MScleanuptask" />
<keyword name="sp_MScontractsubsnb" />
<keyword name="sp_MScreate_dist_tables" />
<keyword name="sp_MScreate_distributor_tables" />
<keyword name="sp_MScreate_mergesystables" />
<keyword name="sp_MScreate_pub_tables" />
<keyword name="sp_MScreate_replication_checkup_agent" />
<keyword name="sp_MScreate_replication_status_table" />
<keyword name="sp_MScreate_sub_tables" />
<keyword name="sp_MScreateglobalreplica" />
<keyword name="sp_MScreateretry" />
<keyword name="sp_MSdbuseraccess" />
<keyword name="sp_MSdbuserpriv" />
<keyword name="sp_MSdeletecontents" />
<keyword name="sp_MSdeletepushagent" />
<keyword name="sp_MSdeleteretry" />
<keyword name="sp_MSdelrow" />
<keyword name="sp_MSdelsubrows" />
<keyword name="sp_MSdependencies" />
<keyword name="sp_MSdoesfilterhaveparent" />
<keyword name="sp_MSdrop_6x_replication_agent" />
<keyword name="sp_MSdrop_distributor_alerts_and_responses" />
<keyword name="sp_MSdrop_mergesystables" />
<keyword name="sp_MSdrop_object" />
<keyword name="sp_MSdrop_pub_tables" />
<keyword name="sp_MSdrop_replcom" />
<keyword name="sp_MSdrop_repltran" />
<keyword name="sp_MSdrop_rladmin" />
<keyword name="sp_MSdrop_rlcore" />
<keyword name="sp_MSdrop_rlrecon" />
<keyword name="sp_MSdroparticleprocs" />
<keyword name="sp_MSdroparticletombstones" />
<keyword name="sp_MSdroparticletriggers" />
<keyword name="sp_MSdropconstraints" />
<keyword name="sp_MSdropmergepub_snapshot" />
<keyword name="sp_MSdropretry" />
<keyword name="sp_MSdummyupdate" />
<keyword name="sp_MSenum3rdpartypublications" />
<keyword name="sp_MSenum_replication_agents" />
<keyword name="sp_MSenum_replication_job" />
<keyword name="sp_MSenumallpublications" />
<keyword name="sp_MSenumchanges" />
<keyword name="sp_MSenumcolumns" />
<keyword name="sp_MSenumdeletesmetadata" />
<keyword name="sp_MSenumgenerations" />
<keyword name="sp_MSenummergepublications" />
<keyword name="sp_MSenumpartialchanges" />
<keyword name="sp_MSenumpartialdeletes" />
<keyword name="sp_MSenumpubreferences" />
<keyword name="sp_MSenumreplicas" />
<keyword name="sp_MSenumretries" />
<keyword name="sp_MSenumschemachange" />
<keyword name="sp_MSenumtranpublications" />
<keyword name="sp_MSexists_file" />
<keyword name="sp_MSexpandbelongs" />
<keyword name="sp_MSexpandnotbelongs" />
<keyword name="sp_MSexpandsubsnb" />
<keyword name="sp_MSfilterclause" />
<keyword name="sp_MSflush_access_cache" />
<keyword name="sp_MSflush_command" />
<keyword name="sp_MSforeach_worker" />
<keyword name="sp_MSforeachdb" />
<keyword name="sp_MSforeachtable" />
<keyword name="sp_MSgen_sync_tran_procs" />
<keyword name="sp_MSgenreplnickname" />
<keyword name="sp_MSgentablenickname" />
<keyword name="sp_MSget_col_position" />
<keyword name="sp_MSget_colinfo" />
<keyword name="sp_MSget_oledbinfo" />
<keyword name="sp_MSget_publisher_rpc" />
<keyword name="sp_MSget_qualifed_name" />
<keyword name="sp_MSget_synctran_commands" />
<keyword name="sp_MSget_type" />
<keyword name="sp_MSgetalertinfo" />
<keyword name="sp_MSgetchangecount" />
<keyword name="sp_MSgetconflictinsertproc" />
<keyword name="sp_MSgetlastrecgen" />
<keyword name="sp_MSgetlastsentgen" />
<keyword name="sp_MSgetonerow" />
<keyword name="sp_MSgetreplicainfo" />
<keyword name="sp_MSgetreplnick" />
<keyword name="sp_MSgetrowmetadata" />
<keyword name="sp_MSguidtostr" />
<keyword name="sp_MShelp_distdb" />
<keyword name="sp_MShelp_replication_status" />
<keyword name="sp_MShelpcolumns" />
<keyword name="sp_MShelpfulltextindex" />
<keyword name="sp_MShelpindex" />
<keyword name="sp_MShelpmergearticles" />
<keyword name="sp_MShelpobjectpublications" />
<keyword name="sp_MShelptype" />
<keyword name="sp_MSindexcolfrombin" />
<keyword name="sp_MSindexspace" />
<keyword name="sp_MSinit_replication_perfmon" />
<keyword name="sp_MSinsertcontents" />
<keyword name="sp_MSinsertdeleteconflict" />
<keyword name="sp_MSinsertgenhistory" />
<keyword name="sp_MSinsertschemachange" />
<keyword name="sp_MSis_col_replicated" />
<keyword name="sp_MSis_pk_col" />
<keyword name="sp_MSkilldb" />
<keyword name="sp_MSload_replication_status" />
<keyword name="sp_MSlocktable" />
<keyword name="sp_MSloginmappings" />
<keyword name="sp_MSmakearticleprocs" />
<keyword name="sp_MSmakeconflictinsertproc" />
<keyword name="sp_MSmakeexpandproc" />
<keyword name="sp_MSmakegeneration" />
<keyword name="sp_MSmakeinsertproc" />
<keyword name="sp_MSmakejoinfilter" />
<keyword name="sp_MSmakeselectproc" />
<keyword name="sp_MSmakesystableviews" />
<keyword name="sp_MSmaketempinsertproc" />
<keyword name="sp_MSmakeupdateproc" />
<keyword name="sp_MSmakeviewproc" />
<keyword name="sp_MSmaptype" />
<keyword name="sp_MSmark_proc_norepl" />
<keyword name="sp_MSmatchkey" />
<keyword name="sp_MSmergepublishdb" />
<keyword name="sp_MSmergesubscribedb" />
<keyword name="sp_MSobjectprivs" />
<keyword name="sp_MSpad_command" />
<keyword name="sp_MSproxiedmetadata" />
<keyword name="sp_MSpublicationcleanup" />
<keyword name="sp_MSpublicationview" />
<keyword name="sp_MSpublishdb" />
<keyword name="sp_MSrefcnt" />
<keyword name="sp_MSregistersubscription" />
<keyword name="sp_MSreinit_failed_subscriptions" />
<keyword name="sp_MSrepl_addrolemember" />
<keyword name="sp_MSrepl_dbrole" />
<keyword name="sp_MSrepl_droprolemember" />
<keyword name="sp_MSrepl_encrypt" />
<keyword name="sp_MSrepl_linkedservers_rowset" />
<keyword name="sp_MSrepl_startup" />
<keyword name="sp_MSreplcheck_connection" />
<keyword name="sp_MSreplcheck_publish" />
<keyword name="sp_MSreplcheck_pull" />
<keyword name="sp_MSreplcheck_subscribe" />
<keyword name="sp_MSreplicationcompatlevel" />
<keyword name="sp_MSreplrole" />
<keyword name="sp_MSreplsup_table_has_pk" />
<keyword name="sp_MSscript_beginproc" />
<keyword name="sp_MSscript_begintrig1" />
<keyword name="sp_MSscript_begintrig2" />
<keyword name="sp_MSscript_delete_statement" />
<keyword name="sp_MSscript_dri" />
<keyword name="sp_MSscript_endproc" />
<keyword name="sp_MSscript_endtrig" />
<keyword name="sp_MSscript_insert_statement" />
<keyword name="sp_MSscript_multirow_trigger" />
<keyword name="sp_MSscript_params" />
<keyword name="sp_MSscript_security" />
<keyword name="sp_MSscript_singlerow_trigger" />
<keyword name="sp_MSscript_sync_del_proc" />
<keyword name="sp_MSscript_sync_del_trig" />
<keyword name="sp_MSscript_sync_ins_proc" />
<keyword name="sp_MSscript_sync_ins_trig" />
<keyword name="sp_MSscript_sync_upd_proc" />
<keyword name="sp_MSscript_sync_upd_trig" />
<keyword name="sp_MSscript_trigger_assignment" />
<keyword name="sp_MSscript_trigger_exec_rpc" />
<keyword name="sp_MSscript_trigger_fetch_statement" />
<keyword name="sp_MSscript_trigger_update_checks" />
<keyword name="sp_MSscript_trigger_updates" />
<keyword name="sp_MSscript_trigger_variables" />
<keyword name="sp_MSscript_update_statement" />
<keyword name="sp_MSscript_where_clause" />
<keyword name="sp_MSscriptdatabase" />
<keyword name="sp_MSscriptdb_worker" />
<keyword name="sp_MSsetaccesslist" />
<keyword name="sp_MSsetalertinfo" />
<keyword name="sp_MSsetartprocs" />
<keyword name="sp_MSsetbit" />
<keyword name="sp_MSsetconflictscript" />
<keyword name="sp_MSsetconflicttable" />
<keyword name="sp_MSsetfilteredstatus" />
<keyword name="sp_MSsetfilterparent" />
<keyword name="sp_MSsetlastrecgen" />
<keyword name="sp_MSsetlastsentgen" />
<keyword name="sp_MSsetreplicainfo" />
<keyword name="sp_MSsetreplicastatus" />
<keyword name="sp_MSsetrowmetadata" />
<keyword name="sp_MSsettopology" />
<keyword name="sp_MSsetupbelongs" />
<keyword name="sp_MSsubscribedb" />
<keyword name="sp_MSsubscriptions" />
<keyword name="sp_MSsubscriptionvalidated" />
<keyword name="sp_MSsubsetpublication" />
<keyword name="sp_MStable_has_unique_index" />
<keyword name="sp_MStable_not_modifiable" />
<keyword name="sp_MStablechecks" />
<keyword name="sp_MStablekeys" />
<keyword name="sp_MStablenamefromnick" />
<keyword name="sp_MStablenickname" />
<keyword name="sp_MStablerefs" />
<keyword name="sp_MStablespace" />
<keyword name="sp_MStestbit" />
<keyword name="sp_MStextcolstatus" />
<keyword name="sp_MSunc_to_drive" />
<keyword name="sp_MSuniquecolname" />
<keyword name="sp_MSuniquename" />
<keyword name="sp_MSuniqueobjectname" />
<keyword name="sp_MSuniquetempname" />
<keyword name="sp_MSunmarkreplinfo" />
<keyword name="sp_MSunregistersubscription" />
<keyword name="sp_MSupdate_agenttype_default" />
<keyword name="sp_MSupdate_replication_status" />
<keyword name="sp_MSupdatecontents" />
<keyword name="sp_MSupdategenhistory" />
<keyword name="sp_MSupdateschemachange" />
<keyword name="sp_MSupdatesysmergearticles" />
<keyword name="sp_MSuplineageversion" />
<keyword name="sp_MSvalidatearticle" />
<keyword name="sp_OACreate" />
<keyword name="sp_OADestroy" />
<keyword name="sp_OAGetErrorInfo" />
<keyword name="sp_OAGetProperty" />
<keyword name="sp_OAMethod" />
<keyword name="sp_OASetProperty" />
<keyword name="sp_OAStop" />
<keyword name="sp_abort_xact" />
<keyword name="sp_add_agent_parameter" />
<keyword name="sp_add_agent_profile" />
<keyword name="sp_add_server_sortinfo" />
<keyword name="sp_addalias" />
<keyword name="sp_addapprole" />
<keyword name="sp_addarticle" />
<keyword name="sp_adddistpublisher" />
<keyword name="sp_adddistributiondb" />
<keyword name="sp_adddistributor" />
<keyword name="sp_addextendedproc" />
<keyword name="sp_addgroup" />
<keyword name="sp_addlinkedserver" />
<keyword name="sp_addlinkedsrvlogin" />
<keyword name="sp_addlogin" />
<keyword name="sp_addmergearticle" />
<keyword name="sp_addmergefilter" />
<keyword name="sp_addmergepublication" />
<keyword name="sp_addmergepullsubscription" />
<keyword name="sp_addmergepullsubscription_agent" />
<keyword name="sp_addmergesubscription" />
<keyword name="sp_addmessage" />
<keyword name="sp_addpublication" />
<keyword name="sp_addpublication_snapshot" />
<keyword name="sp_addpublisher" />
<keyword name="sp_addpullsubscription" />
<keyword name="sp_addpullsubscription_agent" />
<keyword name="sp_addremotelogin" />
<keyword name="sp_addrole" />
<keyword name="sp_addrolemember" />
<keyword name="sp_addserver" />
<keyword name="sp_addsrvrolemember" />
<keyword name="sp_addsubscriber" />
<keyword name="sp_addsubscriber_schedule" />
<keyword name="sp_addsubscription" />
<keyword name="sp_addsynctriggers" />
<keyword name="sp_addtype" />
<keyword name="sp_addumpdevice" />
<keyword name="sp_adduser" />
<keyword name="sp_altermessage" />
<keyword name="sp_approlepassword" />
<keyword name="sp_article_validation" />
<keyword name="sp_articlecolumn" />
<keyword name="sp_articlefilter" />
<keyword name="sp_articlesynctranprocs" />
<keyword name="sp_articleview" />
<keyword name="sp_attach_db" />
<keyword name="sp_attach_single_file_db" />
<keyword name="sp_autostats" />
<keyword name="sp_bindefault" />
<keyword name="sp_bindrule" />
<keyword name="sp_bindsession" />
<keyword name="sp_blockcnt" />
<keyword name="sp_catalogs" />
<keyword name="sp_catalogs_rowset" />
<keyword name="sp_certify_removable" />
<keyword name="sp_change_subscription_properties" />
<keyword name="sp_change_users_login" />
<keyword name="sp_changearticle" />
<keyword name="sp_changedbowner" />
<keyword name="sp_changedistpublisher" />
<keyword name="sp_changedistributiondb" />
<keyword name="sp_changedistributor_password" />
<keyword name="sp_changedistributor_property" />
<keyword name="sp_changegroup" />
<keyword name="sp_changemergearticle" />
<keyword name="sp_changemergefilter" />
<keyword name="sp_changemergepublication" />
<keyword name="sp_changemergepullsubscription" />
<keyword name="sp_changemergesubscription" />
<keyword name="sp_changeobjectowner" />
<keyword name="sp_changepublication" />
<keyword name="sp_changesubscriber" />
<keyword name="sp_changesubscriber_schedule" />
<keyword name="sp_changesubscription" />
<keyword name="sp_changesubstatus" />
<keyword name="sp_check_for_sync_trigger" />
<keyword name="sp_check_removable" />
<keyword name="sp_check_removable_sysusers" />
<keyword name="sp_check_sync_trigger" />
<keyword name="sp_checknames" />
<keyword name="sp_cleanupwebtask" />
<keyword name="sp_column_privileges" />
<keyword name="sp_column_privileges_ex" />
<keyword name="sp_column_privileges_rowset" />
<keyword name="sp_columns" />
<keyword name="sp_columns_ex" />
<keyword name="sp_columns_rowset" />
<keyword name="sp_commit_xact" />
<keyword name="sp_configure" />
<keyword name="sp_create_removable" />
<keyword name="sp_createorphan" />
<keyword name="sp_createstats" />
<keyword name="sp_cursor" />
<keyword name="sp_cursor_list" />
<keyword name="sp_cursorclose" />
<keyword name="sp_cursorexecute" />
<keyword name="sp_cursorfetch" />
<keyword name="sp_cursoropen" />
<keyword name="sp_cursoroption" />
<keyword name="sp_cursorprepare" />
<keyword name="sp_cursorunprepare" />
<keyword name="sp_databases" />
<keyword name="sp_datatype_info" />
<keyword name="sp_db_upgrade" />
<keyword name="sp_dbcmptlevel" />
<keyword name="sp_dbfixedrolepermission" />
<keyword name="sp_dboption" />
<keyword name="sp_dbremove" />
<keyword name="sp_ddopen" />
<keyword name="sp_defaultdb" />
<keyword name="sp_defaultlanguage" />
<keyword name="sp_deletemergeconflictrow" />
<keyword name="sp_denylogin" />
<keyword name="sp_depends" />
<keyword name="sp_describe_cursor" />
<keyword name="sp_describe_cursor_columns" />
<keyword name="sp_describe_cursor_tables" />
<keyword name="sp_detach_db" />
<keyword name="sp_diskdefault" />
<keyword name="sp_distcounters" />
<keyword name="sp_drop_agent_parameter" />
<keyword name="sp_drop_agent_profile" />
<keyword name="sp_dropalias" />
<keyword name="sp_dropapprole" />
<keyword name="sp_droparticle" />
<keyword name="sp_dropdevice" />
<keyword name="sp_dropdistpublisher" />
<keyword name="sp_dropdistributiondb" />
<keyword name="sp_dropdistributor" />
<keyword name="sp_dropextendedproc" />
<keyword name="sp_dropgroup" />
<keyword name="sp_droplinkedsrvlogin" />
<keyword name="sp_droplogin" />
<keyword name="sp_dropmergearticle" />
<keyword name="sp_dropmergefilter" />
<keyword name="sp_dropmergepublication" />
<keyword name="sp_dropmergepullsubscription" />
<keyword name="sp_dropmergesubscription" />
<keyword name="sp_dropmessage" />
<keyword name="sp_droporphans" />
<keyword name="sp_droppublication" />
<keyword name="sp_droppublisher" />
<keyword name="sp_droppullsubscription" />
<keyword name="sp_dropremotelogin" />
<keyword name="sp_droprole" />
<keyword name="sp_droprolemember" />
<keyword name="sp_dropserver" />
<keyword name="sp_dropsrvrolemember" />
<keyword name="sp_dropsubscriber" />
<keyword name="sp_dropsubscription" />
<keyword name="sp_droptype" />
<keyword name="sp_dropuser" />
<keyword name="sp_dropwebtask" />
<keyword name="sp_dsninfo" />
<keyword name="sp_enumcodepages" />
<keyword name="sp_enumcustomresolvers" />
<keyword name="sp_enumdsn" />
<keyword name="sp_enumfullsubscribers" />
<keyword name="sp_enumoledbdatasources" />
<keyword name="sp_execute" />
<keyword name="sp_executesql" />
<keyword name="sp_fallback_MS_sel_fb_svr" />
<keyword name="sp_fetchshowcmdsinput" />
<keyword name="sp_fixindex" />
<keyword name="sp_fkeys" />
<keyword name="sp_foreign_keys_rowset" />
<keyword name="sp_foreignkeys" />
<keyword name="sp_fulltext_catalog" />
<keyword name="sp_fulltext_column" />
<keyword name="sp_fulltext_database" />
<keyword name="sp_fulltext_getdata" />
<keyword name="sp_fulltext_service" />
<keyword name="sp_fulltext_table" />
<keyword name="sp_generatefilters" />
<keyword name="sp_get_distributor" />
<keyword name="sp_getarticlepkcolbitmap" />
<keyword name="sp_getbindtoken" />
<keyword name="sp_getmergedeletetype" />
<keyword name="sp_gettypestring" />
<keyword name="sp_grant_publication_access" />
<keyword name="sp_grantdbaccess" />
<keyword name="sp_grantlogin" />
<keyword name="sp_help" />
<keyword name="sp_help_agent_default" />
<keyword name="sp_help_agent_parameter" />
<keyword name="sp_help_agent_profile" />
<keyword name="sp_help_fulltext_catalogs" />
<keyword name="sp_help_fulltext_catalogs_cursor" />
<keyword name="sp_help_fulltext_columns" />
<keyword name="sp_help_fulltext_columns_cursor" />
<keyword name="sp_help_fulltext_tables" />
<keyword name="sp_help_fulltext_tables_cursor" />
<keyword name="sp_help_publication_access" />
<keyword name="sp_helpallowmerge_publication" />
<keyword name="sp_helparticle" />
<keyword name="sp_helparticlecolumns" />
<keyword name="sp_helpconstraint" />
<keyword name="sp_helpdb" />
<keyword name="sp_helpdbfixedrole" />
<keyword name="sp_helpdevice" />
<keyword name="sp_helpdistpublisher" />
<keyword name="sp_helpdistributiondb" />
<keyword name="sp_helpdistributor" />
<keyword name="sp_helpdistributor_properties" />
<keyword name="sp_helpextendedproc" />
<keyword name="sp_helpfile" />
<keyword name="sp_helpfilegroup" />
<keyword name="sp_helpgroup" />
<keyword name="sp_helpindex" />
<keyword name="sp_helplanguage" />
<keyword name="sp_helplog" />
<keyword name="sp_helplogins" />
<keyword name="sp_helpmergearticle" />
<keyword name="sp_helpmergearticleconflicts" />
<keyword name="sp_helpmergeconflictrows" />
<keyword name="sp_helpmergedeleteconflictrows" />
<keyword name="sp_helpmergefilter" />
<keyword name="sp_helpmergepublication" />
<keyword name="sp_helpmergepullsubscription" />
<keyword name="sp_helpmergesubscription" />
<keyword name="sp_helpntgroup" />
<keyword name="sp_helppublication" />
<keyword name="sp_helppublication_snapshot" />
<keyword name="sp_helppublicationsync" />
<keyword name="sp_helppullsubscription" />
<keyword name="sp_helpremotelogin" />
<keyword name="sp_helpreplicationdb" />
<keyword name="sp_helpreplicationdboption" />
<keyword name="sp_helpreplicationoption" />
<keyword name="sp_helprole" />
<keyword name="sp_helprolemember" />
<keyword name="sp_helprotect" />
<keyword name="sp_helpserver" />
<keyword name="sp_helpsort" />
<keyword name="sp_helpsql" />
<keyword name="sp_helpsrvrole" />
<keyword name="sp_helpsrvrolemember" />
<keyword name="sp_helpstartup" />
<keyword name="sp_helpsubscriber" />
<keyword name="sp_helpsubscriberinfo" />
<keyword name="sp_helpsubscription" />
<keyword name="sp_helpsubscription_properties" />
<keyword name="sp_helptext" />
<keyword name="sp_helptrigger" />
<keyword name="sp_helpuser" />
<keyword name="sp_indexes" />
<keyword name="sp_indexes_rowset" />
<keyword name="sp_indexoption" />
<keyword name="sp_isarticlecolbitset" />
<keyword name="sp_link_publication" />
<keyword name="sp_linkedservers" />
<keyword name="sp_linkedservers_rowset" />
<keyword name="sp_lock" />
<keyword name="sp_lockinfo" />
<keyword name="sp_logdevice" />
<keyword name="sp_makestartup" />
<keyword name="sp_makewebtask" />
<keyword name="sp_mergedummyupdate" />
<keyword name="sp_mergesubscription_cleanup" />
<keyword name="sp_mergesubscriptioncleanup" />
<keyword name="sp_monitor" />
<keyword name="sp_msupg_createcatalogcomputedcols" />
<keyword name="sp_msupg_dosystabcatalogupgrades" />
<keyword name="sp_msupg_dropcatalogcomputedcols" />
<keyword name="sp_msupg_recreatecatalogfaketables" />
<keyword name="sp_msupg_recreatesystemviews" />
<keyword name="sp_msupg_removesystemcomputedcolumns" />
<keyword name="sp_msupg_upgradecatalog" />
<keyword name="sp_objectfilegroup" />
<keyword name="sp_oledbinfo" />
<keyword name="sp_password" />
<keyword name="sp_pkeys" />
<keyword name="sp_prepare" />
<keyword name="sp_primary_keys_rowset" />
<keyword name="sp_primarykeys" />
<keyword name="sp_probe_xact" />
<keyword name="sp_procedure_params_rowset" />
<keyword name="sp_procedures_rowset" />
<keyword name="sp_processinfo" />
<keyword name="sp_processmail" />
<keyword name="sp_procoption" />
<keyword name="sp_provider_types_rowset" />
<keyword name="sp_publication_validation" />
<keyword name="sp_publishdb" />
<keyword name="sp_recompile" />
<keyword name="sp_refreshsubscriptions" />
<keyword name="sp_refreshview" />
<keyword name="sp_reinitmergepullsubscription" />
<keyword name="sp_reinitmergesubscription" />
<keyword name="sp_reinitpullsubscription" />
<keyword name="sp_reinitsubscription" />
<keyword name="sp_remoteoption" />
<keyword name="sp_remove_tempdb_file" />
<keyword name="sp_remove_xact" />
<keyword name="sp_removedbreplication" />
<keyword name="sp_removesrvreplication" />
<keyword name="sp_rename" />
<keyword name="sp_renamedb" />
<keyword name="sp_replcmds" />
<keyword name="sp_replcounters" />
<keyword name="sp_repldone" />
<keyword name="sp_replflush" />
<keyword name="sp_replica" />
<keyword name="sp_replication_agent_checkup" />
<keyword name="sp_replicationdboption" />
<keyword name="sp_replicationoption" />
<keyword name="sp_replincrementlsn" />
<keyword name="sp_replpostcmd" />
<keyword name="sp_replsetoriginator" />
<keyword name="sp_replshowcmds" />
<keyword name="sp_replsync" />
<keyword name="sp_repltrans" />
<keyword name="sp_replupdateschema" />
<keyword name="sp_reset_connection" />
<keyword name="sp_revoke_publication_access" />
<keyword name="sp_revokedbaccess" />
<keyword name="sp_revokelogin" />
<keyword name="sp_runwebtask" />
<keyword name="sp_scan_xact" />
<keyword name="sp_schemata_rowset" />
<keyword name="sp_script_synctran_commands" />
<keyword name="sp_scriptdelproc" />
<keyword name="sp_scriptinsproc" />
<keyword name="sp_scriptmappedupdproc" />
<keyword name="sp_scriptpkwhereclause" />
<keyword name="sp_scriptupdateparams" />
<keyword name="sp_scriptupdproc" />
<keyword name="sp_sdidebug" />
<keyword name="sp_sem_start_mail" />
<keyword name="sp_server_info" />
<keyword name="sp_serveroption" />
<keyword name="sp_setapprole" />
<keyword name="sp_setnetname" />
<keyword name="sp_spaceused" />
<keyword name="sp_special_columns" />
<keyword name="sp_sproc_columns" />
<keyword name="sp_sqlexec" />
<keyword name="sp_sqlregister" />
<keyword name="sp_srvrolepermission" />
<keyword name="sp_start_xact" />
<keyword name="sp_stat_xact" />
<keyword name="sp_statistics" />
<keyword name="sp_statistics_rowset" />
<keyword name="sp_stored_procedures" />
<keyword name="sp_subscribe" />
<keyword name="sp_subscription_cleanup" />
<keyword name="sp_subscriptioncleanup" />
<keyword name="sp_table_privileges" />
<keyword name="sp_table_privileges_ex" />
<keyword name="sp_table_privileges_rowset" />
<keyword name="sp_table_validation" />
<keyword name="sp_tableoption" />
<keyword name="sp_tables" />
<keyword name="sp_tables_ex" />
<keyword name="sp_tables_info_rowset" />
<keyword name="sp_tables_rowset" />
<keyword name="sp_tempdbspace" />
<keyword name="sp_unbindefault" />
<keyword name="sp_unbindrule" />
<keyword name="sp_unmakestartup" />
<keyword name="sp_unprepare" />
<keyword name="sp_unsubscribe" />
<keyword name="sp_updatestats" />
<keyword name="sp_user_counter1" />
<keyword name="sp_user_counter10" />
<keyword name="sp_user_counter2" />
<keyword name="sp_user_counter3" />
<keyword name="sp_user_counter4" />
<keyword name="sp_user_counter5" />
<keyword name="sp_user_counter6" />
<keyword name="sp_user_counter7" />
<keyword name="sp_user_counter8" />
<keyword name="sp_user_counter9" />
<keyword name="sp_validatelogins" />
<keyword name="sp_validlang" />
<keyword name="sp_validname" />
<keyword name="sp_who" />
<keyword name="sp_who2" />
<keyword name="spt_committab" />
<keyword name="spt_datatype_info" />
<keyword name="spt_datatype_info_ext" />
<keyword name="spt_fallback_db" />
<keyword name="spt_fallback_dev" />
<keyword name="spt_fallback_usg" />
<keyword name="spt_monitor" />
<keyword name="spt_provider_types" />
<keyword name="spt_server_info" />
<keyword name="spt_values" />
<keyword name="sysallocations" />
<keyword name="sysalternates" />
<keyword name="sysaltfiles" />
<keyword name="syscacheobjects" />
<keyword name="syscharsets" />
<keyword name="syscolumns" />
<keyword name="syscomments" />
<keyword name="sysconfigures" />
<keyword name="sysconstraints" />
<keyword name="syscurconfigs" />
<keyword name="syscursorcolumns" />
<keyword name="syscursorrefs" />
<keyword name="syscursors" />
<keyword name="syscursortables" />
<keyword name="sysdatabases" />
<keyword name="sysdepends" />
<keyword name="sysdevices" />
<keyword name="sysfilegroups" />
<keyword name="sysfiles" />
<keyword name="sysfiles1" />
<keyword name="sysforeignkeys" />
<keyword name="sysfulltextcatalogs" />
<keyword name="sysindexes" />
<keyword name="sysindexkeys" />
<keyword name="syslanguages" />
<keyword name="syslockinfo" />
<keyword name="syslocks" />
<keyword name="syslogins" />
<keyword name="sysmembers" />
<keyword name="sysmessages" />
<keyword name="sysobjects" />
<keyword name="sysoledbusers" />
<keyword name="sysperfinfo" />
<keyword name="syspermissions" />
<keyword name="sysprocesses" />
<keyword name="sysprotects" />
<keyword name="sysreferences" />
<keyword name="sysremotelogins" />
<keyword name="syssegments" />
<keyword name="sysservers" />
<keyword name="systypes" />
<keyword name="sysusers" />
<keyword name="sysxlogins" />
<keyword name="xp_availablemedia" />
<keyword name="xp_check_query_results" />
<keyword name="xp_cleanupwebtask" />
<keyword name="xp_cmdshell" />
<keyword name="xp_deletemail" />
<keyword name="xp_dirtree" />
<keyword name="xp_displayparamstmt" />
<keyword name="xp_dropwebtask" />
<keyword name="xp_dsninfo" />
<keyword name="xp_enum_activescriptengines" />
<keyword name="xp_enum_oledb_providers" />
<keyword name="xp_enumcodepages" />
<keyword name="xp_enumdsn" />
<keyword name="xp_enumerrorlogs" />
<keyword name="xp_enumgroups" />
<keyword name="xp_eventlog" />
<keyword name="xp_execresultset" />
<keyword name="xp_fileexist" />
<keyword name="xp_findnextmsg" />
<keyword name="xp_fixeddrives" />
<keyword name="xp_get_mapi_default_profile" />
<keyword name="xp_get_mapi_profiles" />
<keyword name="xp_get_tape_devices" />
<keyword name="xp_getfiledetails" />
<keyword name="xp_getnetname" />
<keyword name="xp_grantlogin" />
<keyword name="xp_initcolvs" />
<keyword name="xp_intersectbitmaps" />
<keyword name="xp_load_dummy_handlers" />
<keyword name="xp_logevent" />
<keyword name="xp_loginconfig" />
<keyword name="xp_logininfo" />
<keyword name="xp_makewebtask" />
<keyword name="xp_mergexpusage" />
<keyword name="xp_msver" />
<keyword name="xp_msx_enlist" />
<keyword name="xp_ntsec_enumdomains" />
<keyword name="xp_ntsec_enumgroups" />
<keyword name="xp_ntsec_enumusers" />
<keyword name="xp_oledbinfo" />
<keyword name="xp_param_dump" />
<keyword name="xp_perfend" />
<keyword name="xp_perfmonitor" />
<keyword name="xp_perfsample" />
<keyword name="xp_perfstart" />
<keyword name="xp_printstatements" />
<keyword name="xp_proxiedmetadata" />
<keyword name="xp_qv" />
<keyword name="xp_readerrorlog" />
<keyword name="xp_readmail" />
<keyword name="xp_regaddmultistring" />
<keyword name="xp_regdeletekey" />
<keyword name="xp_regdeletevalue" />
<keyword name="xp_regenumvalues" />
<keyword name="xp_regread" />
<keyword name="xp_regremovemultistring" />
<keyword name="xp_regwrite" />
<keyword name="xp_revokelogin" />
<keyword name="xp_runwebtask" />
<keyword name="xp_sendmail" />
<keyword name="xp_servicecontrol" />
<keyword name="xp_showcolv" />
<keyword name="xp_showlineage" />
<keyword name="xp_snmp_getstate" />
<keyword name="xp_snmp_raisetrap" />
<keyword name="xp_sprintf" />
<keyword name="xp_sqlagent_enum_jobs" />
<keyword name="xp_sqlagent_is_starting" />
<keyword name="xp_sqlagent_monitor" />
<keyword name="xp_sqlagent_notify" />
<keyword name="xp_sqlinventory" />
<keyword name="xp_sqlmaint" />
<keyword name="xp_sqlregister" />
<keyword name="xp_sqltrace" />
<keyword name="xp_sscanf" />
<keyword name="xp_startmail" />
<keyword name="xp_stopmail" />
<keyword name="xp_subdirs" />
<keyword name="xp_terminate_process" />
<keyword name="xp_test_mapi_profile" />
<keyword name="xp_trace_addnewqueue" />
<keyword name="xp_trace_deletequeuedefinition" />
<keyword name="xp_trace_destroyqueue" />
<keyword name="xp_trace_enumqueuedefname" />
<keyword name="xp_trace_enumqueuehandles" />
<keyword name="xp_trace_eventclassrequired" />
<keyword name="xp_trace_flushqueryhistory" />
<keyword name="xp_trace_generate_event" />
<keyword name="xp_trace_getappfilter" />
<keyword name="xp_trace_getconnectionidfilter" />
<keyword name="xp_trace_getcpufilter" />
<keyword name="xp_trace_getdbidfilter" />
<keyword name="xp_trace_getdurationfilter" />
<keyword name="xp_trace_geteventfilter" />
<keyword name="xp_trace_geteventnames" />
<keyword name="xp_trace_getevents" />
<keyword name="xp_trace_gethostfilter" />
<keyword name="xp_trace_gethpidfilter" />
<keyword name="xp_trace_getindidfilter" />
<keyword name="xp_trace_getntdmfilter" />
<keyword name="xp_trace_getntnmfilter" />
<keyword name="xp_trace_getobjidfilter" />
<keyword name="xp_trace_getqueueautostart" />
<keyword name="xp_trace_getqueuecreateinfo" />
<keyword name="xp_trace_getqueuedestination" />
<keyword name="xp_trace_getqueueproperties" />
<keyword name="xp_trace_getreadfilter" />
<keyword name="xp_trace_getserverfilter" />
<keyword name="xp_trace_getseverityfilter" />
<keyword name="xp_trace_getspidfilter" />
<keyword name="xp_trace_gettextfilter" />
<keyword name="xp_trace_getuserfilter" />
<keyword name="xp_trace_getwritefilter" />
<keyword name="xp_trace_loadqueuedefinition" />
<keyword name="xp_trace_opentracefile" />
<keyword name="xp_trace_pausequeue" />
<keyword name="xp_trace_restartqueue" />
<keyword name="xp_trace_savequeuedefinition" />
<keyword name="xp_trace_setappfilter" />
<keyword name="xp_trace_setconnectionidfilter" />
<keyword name="xp_trace_setcpufilter" />
<keyword name="xp_trace_setdbidfilter" />
<keyword name="xp_trace_setdurationfilter" />
<keyword name="xp_trace_seteventclassrequired" />
<keyword name="xp_trace_seteventfilter" />
<keyword name="xp_trace_sethostfilter" />
<keyword name="xp_trace_sethpidfilter" />
<keyword name="xp_trace_setindidfilter" />
<keyword name="xp_trace_setntdmfilter" />
<keyword name="xp_trace_setntnmfilter" />
<keyword name="xp_trace_setobjidfilter" />
<keyword name="xp_trace_setqueryhistory" />
<keyword name="xp_trace_setqueueautostart" />
<keyword name="xp_trace_setqueuecreateinfo" />
<keyword name="xp_trace_setqueuedestination" />
<keyword name="xp_trace_setreadfilter" />
<keyword name="xp_trace_setserverfilter" />
<keyword name="xp_trace_setseverityfilter" />
<keyword name="xp_trace_setspidfilter" />
<keyword name="xp_trace_settextfilter" />
<keyword name="xp_trace_setuserfilter" />
<keyword name="xp_trace_setwritefilter" />
<keyword name="xp_trace_startconsumer" />
<keyword name="xp_trace_toeventlogconsumer" />
<keyword name="xp_trace_tofileconsumer" />
<keyword name="xp_unc_to_drive" />
<keyword name="xp_unload_dummy_handlers" />
<keyword name="xp_updatecolvbm" />
<keyword name="xp_updatelineage" />
<keyword name="xp_varbintohexstr" />
<keyword name="xp_writesqlinfo" />
</keywords3>
<keywords4 />
</highlighting>
<extensionMap>
<mapping ext="psql" />
<mapping ext="ddl" />
<mapping ext="sql" />
</extensionMap>
</filetype>
@kmatt

kmatt commented Feb 21, 2011

Copy link
Copy Markdown
Author

On Mac, a place in ~/Library/Preferences/PyCharm10/filetypes/SQL.xml

@kmatt

kmatt commented Feb 21, 2011

Copy link
Copy Markdown
Author

Added missing datatype section

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment