This table lists how sql server sql dialect was supported by general sql parser.
There are two supporting levels accroding to how general sql parser handle that sql.
| All
sqls |
Level 1 |
Level 2 |
| add
signature |
Y |
|
| alter
application role |
Y |
|
| alter
assembly |
Y |
|
| alter
asymmetric key |
Y |
|
| alter
authorization |
Y |
|
| alter
broker priority |
|
|
| alter
certificate |
Y |
|
| alter
credential |
Y |
|
| alter
cryptographic provider |
|
|
| alter
database |
Y |
|
| alter
database audit specification |
Y |
|
| alter
database encryption key |
Y |
|
| alter
endpoint |
Y |
|
| alter
event session |
|
|
| alter
fulltext catalog |
Y |
|
| alter
fulltext index |
Y |
|
| alter
fulltext stoplist |
|
|
| alter
function |
Y |
Y |
| alter
index |
Y |
|
| alter
login |
Y |
|
| alter
master key |
Y |
|
| alter
message type |
Y |
|
| alter
partition function |
Y |
|
| alter
partition scheme |
Y |
|
| alter
procedure |
Y |
Y |
| alter
queue |
Y |
|
| alter
remote service binding |
Y |
|
| alter
resource governor |
|
|
| alter
resource pool |
|
|
| alter
role |
Y |
|
| alter
route |
Y |
|
| alter
schema |
Y |
|
| alter
server audit |
|
|
| alater
server audit specification |
|
|
| alter
service |
Y |
|
| alter
service master key |
Y |
|
| alter
symmetric key |
Y |
|
| alter
table |
Y |
Y |
| alter
trigger |
Y |
Y |
| alter
user |
Y |
|
| alter
view |
Y |
Y |
| alter
workload group |
|
|
| alter
xml schema collection |
Y |
|
| backup
database |
Y |
Y |
| backup
certificate |
Y |
Y |
| backup
master key |
Y |
Y |
| backup
service master key |
Y |
Y |
| begin
conversation timer |
Y |
|
| begin
dialog conversation |
Y |
Y |
| begin
distributed transaction |
Y |
|
| begin
transaction |
Y |
Y |
| bulk
insert |
Y |
Y |
| checkpoint |
Y |
|
| close |
Y |
Y |
| close
master key |
Y |
|
| close
symmetric key |
Y |
|
| commit |
Y |
Y |
| continue |
Y |
Y |
| create
aggregate |
Y |
|
| create
application role |
Y |
|
| create
assembly |
Y |
|
| create
asymmetric key |
Y |
|
| create
broker priority |
N |
|
| create
certificate |
Y |
|
| create
contract |
Y |
|
| create
credential |
Y |
|
| create
cryptographic provider |
|
|
| create
database |
Y |
|
| create
default |
Y |
|
| create
endpoint |
Y |
|
| create
event notification |
Y |
|
| create
event session |
|
|
| create
fulltext catalog |
Y |
|
| create
fulltext index |
Y |
|
| create
fulltext stoplist |
|
|
| create
function |
Y |
Y |
| create
index |
Y |
Y |
| create
login |
Y |
|
| create
master key |
Y |
|
| create
partition function |
Y |
|
| create
partition scheme |
Y |
|
| create
procedure |
Y |
Y |
| create
queue |
Y |
|
| create
remote service binding |
Y |
|
| create
resource pool |
|
|
| create
role |
Y |
|
| create
route |
Y |
|
| create
rule |
Y |
|
| create
schema |
Y |
|
| create
server audit |
|
|
| create
server audit specification |
|
|
| create
service |
Y |
|
| create
statistics |
Y |
|
| create
symmetric key |
Y |
|
| create
synonym |
Y |
|
| create
table |
Y |
Y |
| create
trigger |
Y |
Y |
| create
type |
Y |
|
| create
user |
Y |
|
| create
view |
Y |
Y |
| create
workload group |
|
|
| create
xml schema collection |
Y |
|
| dbcc |
Y |
Y |
| deallocate |
Y |
Y |
| declare
cursor |
Y |
Y |
| delete |
Y |
Y |
| deny |
Y |
|
| disable
trigger |
Y |
|
| drop
aggregate |
Y |
Y |
| drop
application role |
Y |
Y |
| drop
assembly |
Y |
Y |
| drop
broker priority |
|
|
| drop
certificate |
Y |
Y |
| drop
contract |
Y |
Y |
| drop
credential |
Y |
Y |
| drop
cryptographic provider |
|
|
| drop
database |
Y |
Y |
| drop
default |
Y |
Y |
| drop
endpoint |
Y |
Y |
| drop
event notification |
Y |
|
| drop
event session |
|
|
| drop
fulltext catalog |
Y |
|
| drop
fulltext index |
Y |
|
| drop
fulltext stoplist |
|
|
| drop
function |
Y |
Y |
| drop
index |
Y |
Y |
| drop
login |
Y |
Y |
| drop
master key |
Y |
|
| drop
message type |
Y |
|
| drop
partition function |
Y |
Y |
| drop
partition scheme |
Y |
Y |
| drop
procedure |
Y |
Y |
| drop
queue |
Y |
Y |
| drop
remote service binding |
Y |
|
| drop
resource pool |
|
|
| drop
role |
Y |
Y |
| drop
route |
Y |
Y |
| drop
rule |
Y |
Y |
| drop
schema |
Y |
Y |
| drop
server audit |
|
|
| drop
server audit specification |
|
|
| drop
service |
Y |
Y |
| drop
signature |
Y |
Y |
| drop
statistics |
Y |
Y |
| drop
symmetric key |
Y |
Y |
| drop
synonym |
Y |
Y |
| drop
table |
Y |
Y |
| drop
trigger |
Y |
Y |
| drop
type |
Y |
Y |
| drop
user |
Y |
Y |
| drop
view |
Y |
Y |
| drop
workload group |
|
|
| drop xml
schema collection |
Y |
|
| execute |
Y |
Y |
| fetch |
Y |
Y |
| goto |
Y |
Y |
| grant |
Y |
Y |
| insert |
Y |
Y |
| kill |
Y |
|
| open |
Y |
Y |
| open
masater key |
|
|
| open
symmetric key |
|
|
| print |
Y |
Y |
| raiserror |
Y |
Y |
| readtext |
Y |
Y |
| receive |
Y |
|
| restore
master key |
Y |
|
| restore
service master key |
Y |
|
| return |
Y |
Y |
| revert |
Y |
Y |
| revoke |
Y |
Y |
| rollback
transaction |
Y |
Y |
| rollback
work |
Y |
Y |
| save
transaction |
Y |
Y |
| select |
Y |
Y |
| send |
Y |
Y |
| set |
Y |
Y |
| setuser |
Y |
|
| shutdown |
Y |
|
| trunncate
table |
Y |
Y |
| update |
Y |
Y |
| updatestatistics |
Y |
Y |
| updatetext |
Y |
Y |
| use |
Y |
Y |
| waitfor |
Y |
Y |
| writetext |
Y |
|
|
|
|