Schema change events should be of type ALTER when table is modified

Currently they are of type CREATE. SqlServerSchemaChangeEventEmitter should be parameterized with the type depending on the use case instead of hard-wiring CREATE.