clear markdown compare help best fiddles feedback dbanow.uk
clear markdown donate comments/suggestions/bugs a leap of faith? bible365 diddy dollings
By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0. 2591614 fiddles created (45712 in the last week).

CREATE TABLE foo ( a int ); INSERT INTO foo VALUES (1),(2),(3);
3 rows affected
 hidden batch(es)


ALTER TABLE foo ADD b varchar ;
 hidden batch(es)


UPDATE foo SET b = CAST( a AS varchar ); ALTER TABLE foo DROP COLUMN a;
3 rows affected
 hidden batch(es)


SELECT * FROM foo;
b
1
2
3
 hidden batch(es)