SQL操作类型总结

操作大类	操作类型
Drop类	drop aggregate、drop application role、drop assembly、drop asymmetric key、drop availability group、drop broker priority、drop certificate、drop contract、drop credential、drop cryptographic provider、drop database、drop database audit specification、drop database encryption key、drop default、drop endpoint、drop event notification、drop event session、drop federation、drop fulltext catalog、drop fulltext index、drop fulltext stoplist、drop function、drop index、drop login、drop master key、drop message type、drop partition function、drop partition scheme、drop procedure、drop queue、drop remote service binding、drop resource pool、drop role、drop route、drop rule、drop schema、drop search property list、drop sequence、drop server audit、drop server audit specification、drop server role、drop service、drop signature、drop statistics、drop symmetric key、drop synonym、drop table、drop trigger、drop type、drop user、drop view、drop workload group、drop xml schema collection、drop audit policy、drop cluster、drop database link、drop dimension、drop directory、drop diskgroup、drop edition、drop flashback archive、drop indextype、drop java class、drop java resource、drop java source、drop library、drop materialized view、drop materialized view log on、drop materialized zonemap、drop operator、drop outline、drop package、drop packagebody、drop pluggable database、drop profile、drop restore point、drop rollback segment、drop tablespace、drop type body
Creat类	create aggregate、create application role、create assembly、create asymmetric key、create broker priority、create certificate、create column store index、create contract、create credential、create cryptographic provider、create database、create database audit specification、create database encryption key、create default、create endpoint、create event notification、create event session、create federation、create fulltext catalog、create fulltext index、create fulltext stoplist、create function、create index、create login、create master key、create message type、create partition function、create partition scheme、create procedure、create queue、create remote service binding、create resource pool、create role、create route、create rule、create schema、create search property list、create selective xml index、create sequence、create server audit、create server audit specification、create server role、create service、create spatial index、create statistics、create symmetric key、create synonym、create table、create trigger、create type、create user、create view、create workload group、create xml index、create xml schema collection、create audit policy、create cluster、create context、create controlfile reuse database、create controlfile set database、create database link、create dimension、create directory、create diskgroup、create edition、create flashback archive、create indextype、create java、create library、create materialized view、create materialized zonemap、create operator、create outline、create or replace package、create or replace packagebody、create pfile、create pluggable database、create profile、create restore point、create rollback segment、create spfile、create tablespace、create temporary table、create temporary tablespace、create undo tablespace、create type body
Alter类	alter application role、alter assembly、alter asymmetric key、alter authorization、alter availability group、alter broker priority、alter certificate、alter credential、alter cryptographic provider、alter database、alter database audit specification、alter database encryption key、alter endpoint、alter event session、alter federation、alter fulltext catalog、alter fulltext index、alter fulltext stoplist、alter function、alter index、alter login、alter master key、alter message type、alter partition function、alter partition scheme、alter procedure、alter queue、alter remote service binding、alter resource governor、alter resource pool、alter role、alter route、alter schema、alter search property list、alter sequence、alter server audit、alter server audit specification、alter server configuration、alter server role、alter service、alter service master key、alter symmetric key、alter synonym、alter table、alter trigger、alter type、alter user、alter view、alter workload group、alter xml schema collection、alter audit policy、alter cluster、alter database link、alter dimension、alter diskgroup、alter flashback archive、alter indextype、alter java class、alter java source、alter library、alter materialized view、alter materialized view log on、alter materialized view log force on、alter materialized zonemap、alter operator、alter outline public、alter outline private、alter pluggable database、alter profile、alter resource cost、alter rollback segment、alter session、alter system、alter tablespace
Comment类	comment table、comment audit policy、comment column、comment edition、comment materialized view、comment model、comment operator
Dbcc类	dbcc checkalloc、dbcc checkcatalog、dbcc checkconstraints、dbcc checkdb、dbcc checkfilegroup、dbcc checkident、dbcc checktable、dbcc cleantable、dbcc dbreindex、dbcc dropcleanbuffers、dbcc freeproccache、dbcc freesessioncache、dbcc freesystemcache、dbcc help、dbcc indexdefrag、dbcc inputbuffer、dbcc opentran、dbcc outputbuffer、dbcc showcontig、dbcc shrinkdatabase、dbcc shrinkfile、dbcc sqlperf、dbcc traceoff、dbcc traceon、dbcc tracestatus、dbcc updateusage、dbcc user options （特殊的sqlserver数据库控制台命令类型）
Grant类	grant role、grant system privilege
Insert类	Bulkinsert
Updata类	update statistics
Delete类
Select类
Kill类	kill query notification subscription、 kill stats job (运维操作)
Set类	set deadlock priority、set forceplan、set role、set user
Analyze	analyze table、analyze cluster (收集统计信息)
Exec函数	exec procedure、exec sql (sqlserver用法)
backup	backup certificate、backup database、backup log、backup master key、backup service master key
Close	close master key、close symmetric key
Open	open master key、open symmetric key
flashback	flashback database、flashback table
use	Use database、use federation
Truncate	Truncate table、truncate cluster
Revoke	Revoke role、revoke system privilege (撤销用户权限)
Restore类	restore database、restore log、restore master key、restore service master key (恢复数据)
其他	disable trigger、 disassociate statistics、 deny、 checkpoint、 associate statistics、 audit、 call、 add signature、 enable trigger、 explain plan、 lock table、 merge、 noaudit、 rename、 reconfigure、