Saturday, February 25, 2012

Add fields to a table

is there a way to add fields to a SQL Server 2005 table using an SQL statement?
Thank You
Hello Mark,
You can use same command as SQL Server 2000 to add columns to the table. For
further details refer the following link:
http://msdn2.microsoft.com/en-us/library/ms190273.aspx
Cheers,
MB
"Mark Shields" <MarkShields@.discussions.microsoft.com> wrote in message
news:120BDFF7-3B50-43B9-BFE0-66A51399BA87@.microsoft.com...
> is there a way to add fields to a SQL Server 2005 table using an SQL
> statement?
>
> Thank You
|||On Jan 31, 4:16 am, Mark Shields
<MarkShie...@.discussions.microsoft.com> wrote:
> is there a way to add fields to a SQL Server 2005 table using an SQL statement?
> Thank You
alter table MENU_ITEM add Price bigint null
This would add the Price column to the MENU_ITEM table as a bigInt
that allows nulls.

No comments:

Post a Comment