« previous next »
Pages: [1]

Author Topic: Generate DDL for SQL Server 2005  (Read 2180 times)

tyhurstrw

  • EA Novice
  • *
  • Posts: 1
  • Karma: +0/-0
  • I love YaBB 1G - SP1!
    • View Profile
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
Logged
Pages: [1]
« previous next »