You are viewing a single comment's thread from:

RE: Create database in Visual Studio

in #sqllast year

Alter Table students ADD(age INT, country Varchar(10), nationality Varchar);
Alter Table students Drop Column nationality;
Alter Table students Modify country Varchar(88);

Sort:  

Update table_name
Set col_name =' Harper Building'
Where department = ' engineering'

image.png