Join the social network of Tech Nerds, increase skill rank, get work, manage projects...
 

  • Change the datatype of a column in SQL Server

    @Mohini
    Recommendations Offline Message

    • 0
    • 0
    • 0
    • 0
    • 0
    • 0
    • 0
    • 0
    • 370
    Comment on it

    Hello Reader!If you wish to add, delete or modify columns in an existing table you can do this with the help of ALTER command.

    The syntax to change or we can say to modify a column in an existing table in SQL server is:

    1. ALTER TABLE table-name
    2. ALTER COLUMN column_name column_type;

    Example:

    1.   ALTER TABLE employees
    2.   ALTER COLUMN first_name VARCHAR(40) NOT NULL;

    Following example will modify the column first_name to be a datatype of VARCHAR(40) and will force a column to not allow null values.

    The syntax to add new column in an existing table in SQL server is:

    1. ALTER TABLE table-name
    2.  ADD column_name datatype;

    Example:

    1. ALTER TABLE employees
    2.  ADD department  varchar(15);

    Following example will add the column department to an existing table employee of datatype VARCHAR with size upto 15 characters.

    SQL
    Comment on it

 0 Comment(s)

Sign In
Forgot Password?
                           OR                           
Create an account !!
                           OR                           
Register

Sign up using

                           OR                           
Forgot Password
Reset Password
Fill out the form below and reset your password: