Hello community
Can someone let me know if there is a sql query that I can run to change the column datatype.
For example, I would like to change column or column's from 'string' to 'integer.
Thanks
Carlton
Hello community
Can someone let me know if there is a sql query that I can run to change the column datatype.
For example, I would like to change column or column's from 'string' to 'integer.
Thanks
Carlton
alter table
bitsmed,
Thanks for reaching out. I will google 'alter table', however could you write it in context of changing a column datatype please
alter table yourtable
alter column yourcolumn varchar(64) not null
;
Might be best to