Create table statement for Microsoft SQL Server

-- DDL script for table TB_INDEX_0055 for Microsoft SQL Server
-- Timestamp: Thu Jan 12 10:40:17 2012

-- Create table statement


IF EXISTS(SELECT * FROM dbo.sysobjects where id = object_id(N'TB_INDEX_0055') and OBJECTPROPERTY(id,N'IsUserTable') = 1)
begin
-- Removing referential constraints before dropping the table
   DECLARE @SWV_DrSt VARCHAR(1024)
   DECLARE SWC_Fk CURSOR FOR select 'ALTER TABLE ['+USER_NAME(sof.uid)+'].['+OBJECT_NAME(SR.fkeyid)+'SQLWAYS_EVAL# ['+OBJECT_NAME(SR.constid)+']'
   from sysreferences sr, sysobjects sof where  sr.rkeyid = OBJECT_ID('TB_INDEX_0055') and sof.id = sr.fkeyid
   OPEN SWC_Fk
   FETCH NEXT FROM SWC_Fk INTO @SWV_DrSt
   WHILE @@FETCH_STATUS = 0
   BEGIN
      EXEC(@SWV_DrSt)
      FETCH NEXT FROM SWC_Fk INTO @SWV_DrSt
   END
   CLOSE SWC_Fk
   DEALLOCATE SWC_Fk
   DROP TABLE TB_INDEX_0055
end


GO
CREATE TABLE TB_INDEX_0055
(
   F0055_001N INT   NOT NULL,
   F0055_002V VARCHAR(200)   NULL,
   F0055_003V VARCHAR(200)   NULL,
   F0055_004V VARCHAR(200)   NULL,
   F0055_005D DATETIME   NULL,
   F0055_006V VARCHAR(24)   NULL,
   F0055_007V VARCHAR(24)   NULL,
   OB_SEQ_ID BIGINT   NULL,
   F0055_008V VARCHAR(24)   NULL
)


GO


-- Primary key

ALTER TABLE TB_INDEX_0055 ADD  CONSTRAINT PK_TB_INDEX_0055
PRIMARY KEY(F0055_001N)
GO