0

How to reset datatype of a field on sql

27th Dec 2018, 10:54 AM
Saad Ahmed
6 Answers
0
Just to clarify, Re-set (change/update) Or Reset (set to default value) ? And please explain your question further, what you want to do with your table
27th Dec 2018, 11:02 AM
Taste
Taste - avatar
0
Like int to char or opposite
27th Dec 2018, 11:08 AM
Saad Ahmed
0
Change
27th Dec 2018, 11:10 AM
Saad Ahmed
0
Use alter table ALTER TABLE table_name MODIFY COLUMN col_name new_datatype
27th Dec 2018, 11:11 AM
Taste
Taste - avatar
0
Thank you
27th Dec 2018, 11:13 AM
Saad Ahmed
0
ALTER TABLE table_name ALTER COLUMN column_name datatype; -- SQL Server ALTER TABLE table_name MODIFY COLUMN column_name datatype; -- My SQL ALTER TABLE table_name MODIFY column_name datatype; -- ORACLE
9th Jan 2019, 12:55 PM
Akwin Lopez
Akwin Lopez - avatar