if exists (select * from sysobjects where id = object_id(N'[dbo].[table_name_Here]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)

drop table [dbo].[table_name_Here]

Create table table_name_Here (ID int) --Name the table here and we will create one static field

select * from table_name_Here -- here is the table before

Declare @SQL varchar(1000)

Declare @Counter int

set @Counter = 1

while @Counter <= 5 -- Change this number to add Columns

set @SQL = 'ALTER TABLE table_name_Here

ADD ColName' + rtrim(convert(char(10),@Counter)) + ' numeric(18,0)'

exec(@SQL)

set @Counter = @Counter + 1

select * from table_name_Here --here is the table after