In ACCESS, the note type is indicated by a note, so the SQL to change the data type of a field to a note is:
Change table user change column user information memo
By the way, if the user table has a foreign key, the field you want to modify is a foreign key, so you can't modify it!
The following are modifications to other types of SQL (table tb, field aa):
Change Table tb Change Column aa Bytes [Bytes]
Alter table TB alter column aa long number [long integer]
ALTER TABLE tb ALTER COLUMN aa short number [integer]
Alter table TB alter column aa single number [single precision
Alter table TB alter column aa double number [double precision]
Change table TB change column aa currency
Change table tb change column aa character text
Alter table TB alter column aa text (n) text, where n represents the field size.
Change table TB change column aa binary
Change table TB change column aa counter automatic numbering
Change table tb change column aa memo remarks
Change Table tb Change Column aa Time Date/Time
All data types in ACCESS are here, hehe!
I found out all these things one by one and passed the test. Very hard! Just to give extra points to the position of manager, choose mine as the best answer, thank you for your cooperation! ……