CHANGE keyword not highlighted about language-sql HOT 4 CLOSED

I don't have direct access to the standard

You might find these resources useful in the future: https://jakewheat.github.io/sql-overview/sql-2016-foundation-grammar.html#_11_10_alter_table_statement and https://crate.io/docs/sql-99/en/latest/chapters/18.html#alter-table-statement (they confirm that CHANGE is non-standard).

from language-sql.

Thanks for the report - do you have a full minimal example that we can copy/paste?

Also, is this keyword MySQL specific or is it supported by other SQL variants?

from language-sql.

CHANGE is a MySQL extension to standard SQL.

According to the latest MySQL documentation this is a non-standard extension to the standard.

An example usage seems to be statements like this:

ALTER TABLE t1 CHANGE a b BIGINT NOT NULL;

Looking over the equivalent PostgreSQL documentation it seems that most of the functionality under ALTER TABLE is non-standard in many implementations, as the standard doesn't specify enough for anything beyond basic functionality. I don't have direct access to the standard though so I'm just guessing here.

from language-sql.

This issue has been automatically closed because there has been no response to our request for more information from the original author. With only the information that is currently in the issue, we don't have enough information to take action. Please reach out if you have or find the answers we need so that we can investigate further.

from language-sql.