search

Google
 

Tuesday, February 5, 2008

Adding a column to a existing Table in SQL Server 2005

USE [Database_Name]
ALTER TABLE [Table_Name]
ADD [Column_Name] Datatype null

Example:-

USE ourspace
ALTER TABLE items ADD Brand varchar(100) null

2 comments:

crickettalk said...

lakshmi garu mee blog chala bagundi
chala useful ga kuda vundi. i am an artist from tirupati plese visit my blog and see some of my arts www.prasadarts.blogspot.com

Laxmi said...

TOOoooooooooooooooooo good :-)

There are no words in my dictionary to describe your arts.

Really great.

I feel every art you have posted needed to be appreciated.