Current location - Plastic Surgery and Aesthetics Network - Plastic surgery and beauty - How to modify the data type of an Access database table
How to modify the data type of an Access database table
Haha, I found it. I passed the test in ACCESS:

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! ……