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.
Today is my first day to read this article, it realy helful……..
example is so simply explain just like any teacher explain vitally……..
thanks sir………..
Pingback: คาสิโน
Pingback: แทงบอลออนไลน์
Pingback: here’s a great place to get started
Pingback: ww88
Pingback: see page
Pingback: https://findahomeincharlottesvilleva.com/
Pingback: cardloan
Pingback: Dave Holmes Coldplay
Pingback: 바카라싸이트
Pingback: circle
Pingback: xembongdatructuyen hom nay
Pingback: Dream Market Exit Scam
Pingback: con heo dat remix
Pingback: https://internetnews.net.pl/forum/nowe-technologie-f7/poznam-opinie-o-funkymedia-t62.html
Pingback: public babe Pov mature
Pingback: trampling mistress Blonde
Pingback: solo babe solo teasing
Pingback: macys jewelry earrings
Pingback: SBOBET
Pingback: replica watches panerai copy
Pingback: Scam
Pingback: Crystal Meth Shop
Pingback: Dream Market
Pingback: เงิน ด่วน โคราช
Pingback: ms88ca
Pingback: Global (AMER, EMEA, BRICS and APAC) B2B Marketplace Platforms Market Size, Status and Forecast 2019-2025
Pingback: https://www.jungle420medsdispensary.com/shop/buy-white-rhino-kush-online/
Pingback: megapoker