Thank you for your comment about the drop index example. I've fixed it.
Indeed my version of create index does not follow SQL standard. Unfortunately discovery of types from data when creating index is not always possible: you can create index when data is not populated yet. However you are right: if index is created when data is already populated, shorter (standard) SQL syntax may be supported.
For further actions, you may consider blocking this person and/or reporting abuse
We're a place where coders share, stay up-to-date and grow their careers.
create indexdoes not follow SQL standard. Unfortunately discovery of types from data when creating index is not always possible: you can create index when data is not populated yet. However you are right: if index is created when data is already populated, shorter (standard) SQL syntax may be supported.