Skip to content

Instantly share code, notes, and snippets.

@kmatt
Created February 21, 2011 20:39
Show Gist options
  • Star 1 You must be signed in to star a gist
  • Fork 1 You must be signed in to fork a gist
  • Save kmatt/837674 to your computer and use it in GitHub Desktop.
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
Copy link
Author

kmatt commented Feb 21, 2011

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

@kmatt
Copy link
Author

kmatt commented Feb 21, 2011

Added missing datatype section

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