• Please note below text marked in bold . As you can see script creation date and time are added in script file. Can we avoid this.

    /****** Object: Table [dbo].[AbandonReason] Script Date: 5/21/2009 1:51:20 PM ******/

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

    drop table [dbo].[table1]

    GO

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

    BEGIN

    CREATE TABLE [dbo].[table1] (