hi!
I use ms sql 2005 "Generate Script Wizard" to generate table schema
Most tables' script are normal,except one.
the script snippet is as following
----------------------------------------------------
IF EXISTS (SELECT * FROM sys.objects WHERE object_id =
OBJECT_ID(N'[dbo].[TABLE_ABC]') AND type in (N'U'))
DROP TABLE [dbo].[TABLE_ABC]
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING OFF
GO
IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id =
OBJECT_ID(N'[dbo].[TABLE_ABC]') AND type in (N'U'))
BEGIN
CREATE TABLE [dbo].[TABLE_ABC](
[ID_NO] [varchar](12) NULL
) ON [PRIMARY]
SET ANSI_PADDING ON
ALTER TABLE [dbo].[TABLE_ABC] ADD [COL001] [varchar](6) NULL
ALTER TABLE [dbo].[TABLE_ABC] ADD [COL002] [char](4) NULL
ALTER TABLE [dbo].[TABLE_ABC] ADD [COL003] [char](4) NULL
ALTER TABLE [dbo].[TABLE_ABC] ADD [COL004] [char](5) NULL
ALTER TABLE [dbo].[TABLE_ABC] ADD [COL005] [char](5) NULL
----------------------------------------------------
I'm curious about why it uses ALTER to add columns?

Can anyone give me an answer?

Thanks a lot!

YGGG,

This is because the table was defined this way. First created, then altered
five times to add columns. Although you (and I, too) would usually like a
clean create table script, the SQL Server is aware of how the table was
created and faithfully mimics that in the script.

RLF

"YesGoGoGo" <YesGoGoGo (AT) gmail (DOT) com> wrote

YGGG,

This is because the table was defined this way. First created, then altered
five times to add columns. Although you (and I, too) would usually like a
clean create table script, the SQL Server is aware of how the table was
created and faithfully mimics that in the script.

RLF

"YesGoGoGo" <YesGoGoGo (AT) gmail (DOT) com> wrote

YGGG,

This is because the table was defined this way. First created, then altered
five times to add columns. Although you (and I, too) would usually like a
clean create table script, the SQL Server is aware of how the table was
created and faithfully mimics that in the script.

RLF

"YesGoGoGo" <YesGoGoGo (AT) gmail (DOT) com> wrote

YGGG,

This is because the table was defined this way. First created, then altered
five times to add columns. Although you (and I, too) would usually like a
clean create table script, the SQL Server is aware of how the table was
created and faithfully mimics that in the script.

RLF

"YesGoGoGo" <YesGoGoGo (AT) gmail (DOT) com> wrote

YGGG,

This is because the table was defined this way. First created, then altered
five times to add columns. Although you (and I, too) would usually like a
clean create table script, the SQL Server is aware of how the table was
created and faithfully mimics that in the script.

RLF

"YesGoGoGo" <YesGoGoGo (AT) gmail (DOT) com> wrote

YGGG,

This is because the table was defined this way. First created, then altered
five times to add columns. Although you (and I, too) would usually like a
clean create table script, the SQL Server is aware of how the table was
created and faithfully mimics that in the script.

RLF

"YesGoGoGo" <YesGoGoGo (AT) gmail (DOT) com> wrote

YGGG,

This is because the table was defined this way. First created, then altered
five times to add columns. Although you (and I, too) would usually like a
clean create table script, the SQL Server is aware of how the table was
created and faithfully mimics that in the script.

RLF

"YesGoGoGo" <YesGoGoGo (AT) gmail (DOT) com> wrote

YGGG,

This is because the table was defined this way. First created, then altered
five times to add columns. Although you (and I, too) would usually like a
clean create table script, the SQL Server is aware of how the table was
created and faithfully mimics that in the script.

RLF

"YesGoGoGo" <YesGoGoGo (AT) gmail (DOT) com> wrote

YGGG,

This is because the table was defined this way. First created, then altered
five times to add columns. Although you (and I, too) would usually like a
clean create table script, the SQL Server is aware of how the table was
created and faithfully mimics that in the script.

RLF

"YesGoGoGo" <YesGoGoGo (AT) gmail (DOT) com> wrote