SQL Online Crash Course – Part 4 – Alter Table

Alter Table Pupil Add
Gender varchar(1),
Size decimal(5,2),
Notes varchar(2000);

Command(s) completed successfully.

Alter Table Pupil Alter Column
Name varchar(128);

Command(s) completed successfully.

Select * From Pupil;

Id    Name    DateBirth    Gender    Size    Notes
1    Charly    2004-01-19 00:00:00.000    NULL    NULL    NULL
2    Sandy    2004-05-14 00:00:00.000    NULL    NULL    NULL
3    Jim    2003-12-01 00:00:00.000    NULL    NULL    NULL

Posted on Dezember 7, 2013 by Chris K in SQL