Messages

1

Suggestions and Requests / Generate DDL for SQL Server 2005

« on: November 07, 2006, 11:47:09 am »

SQL Server Management Studio Express generates the following for droping a table:
USE [EidLoader]
GO
/****** Object:  Table [dbo].[EMITTER_ID_RECORDS]    Script Date: 11/07/2006 11:41:24 ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[EMITTER_ID_RECORDS]') AND type in (N'U'))
DROP TABLE [dbo].[EMITTER_ID_RECORDS]

EA ver. 6.5 generates the following using SQL Server as the database:
USE EidLoader

IF EXISTS (SELECT * FROM dbo.SYSOBJECTS WHERE id = object_id('[dbo].[EMITTER_ID_RECORDS]') AND  OBJECTPROPERTY(id, 'IsUserTable') = 1)
DROP TABLE [dbo].[EMITTER_ID_RECORDS]

Is there away for me to make the mods to the EA DLL generater?

Thanks
Rick