Getting Started with Adobe After Effects - Part 6: Motion Blur


Upload Image Close it
Select File

This blog contains various articles on the SQL Server. Also this blog contains various interview questions on the SQL Server. Through this blog I try to make the learning of SQL Server/ BI and SQL DBA very easy and in a quick time.

Browse by Tags · View All
CodeProject 6
Sql Server 4
Having Clause 3
Interview Questions on sql server 3
SQLServerPediaSyndication 3
Happy New Year 1
Rebuild And Reorganization of Indexes 1
Replication in SQL Server 1
Fragmentation in SQL Server 1
Log Shipping in SQL Server 1

Archive · View All
February 2012 20
December 2012 5
April 2012 4
August 2012 2
November 2010 2
November 2012 1
June 2012 1
May 2011 1
November 2011 1
October 2011 1

Technology With Vivek Johari

Adding , Deleting and Updating a Column in a table

Apr 15 2012 12:00AM by Vivek Johari   

Many times we need to alter the table definition by adding , deleting or updating a column in the table. In this article, I am trying to explain the following :-


1. How to add a column
2. How to update a column
3. How to drop a column


Suppose we have a table say Employee whose structure is given below:-


CREATE TABLE Employee (Emplyeeid int identity(1,1),
Empnumber nvarchar(10),
Firstname nvarchar(50),
Lastname nvarchar(150),
Age int,
Phoneno nvarchar(15),
Address nvarchar(200),
Empdate datetime)


Insert query for Inserting data in the table is given below:-


Insert Into employee Values
('mani123','Manish', 'Arora',27,'245121','Delhi',getdate())


We can see the data in table employee through the following SQL Statement:-


Select * from Employee


Now suppose we want to update the column Firstname of the table Employee by increasing its character limits from 50 to 100.  The SQL statement used for this column updation will be:-


Alter table Employee Alter column Firstname nvarchar(100)


Again suppose we want to add a column Regdate into the table Employee then the Sql statement for adding the column into the table Employee will be given below:-


Alter table Employee Add Regdate datetime null


The above SQL statement will add a nullable column Regdate to the table which have the datatype as datetime.


The insert command after the addition of the new column regdatum will be given below:-


Insert Into employee Values
('VJO','Vivek', 'Johari',28,'244555121','Delhi',getdate(),'01/01/2012')


Select * from Employee






Suppose if we want to delete a column from the table then we have to write the following SQL Statement


Alter Table Employee Drop Column Regdate


This command will drop the column Regdate from the table Employee which we can verify with the help of the select command.


Select * from Employee




from the above picture, it can be easily see that the column Regdate is not a column of the table Employee anymore.


Republished from Technology with Vivek Johari [10 clicks].  Read the original version here [1 clicks].
Vivek Johari
115 · 1% · 445
1
 
0
Lifesaver
 
0
Refreshed
 
0
Learned
 
0
Incorrect


Submit

Your Comment
Sign Up or Login to post a comment.
"Adding , Deleting and Updating a Column in a table" rated 5 out of 5 by 1 readers
Adding , Deleting and Updating a Column in a table , 5.0 out of 5 based on 1 ratings
    Copyright © Rivera Informatic Private Ltd Contact us      Privacy Policy      Terms of use      Report Abuse      Advertising      [ZULU1097]