Add A Column To An Existing Table In Sql

To Add A Column To An Existing Table In Sql Server we use  Alter Statement. The code is below.

Example1:

Add a column to the students table named ‘gender’, data type one character of char

Example1:

Add a column to the students table named ‘gender’, data type one character of char and default value is ‘F’

YOU MAY WANT TO SEE OUR ALL EXAMPLES PAGE, THEN CLICK HERE

Leave a Comment

This site uses Akismet to reduce spam. Learn how your comment data is processed.

%d bloggers like this: