مشكلة فى ال SQL

[khadrdoom]

يا جماعة انا اتمسح من عندى ال Table دى SiegeFortressStruct_ محتاج حد يقولى اعمل اية عشان ارجعه تانى او كويرى عشان اعمل لل Table Create عشان اتمسح من عندى خالص يعنى مش موجود :wallbash:

[Yui]

USE [SHARD]
GO

/****** Object: Table [dbo].[_SiegeFortressStruct] Script Date: 11/24/2014 11:42:27 AM ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

CREATE TABLE [dbo].[_SiegeFortressStruct](
[FortressID] [int] NOT NULL,
[OwnerGuildID] [int] NOT NULL,
[RefEventStructID] [int] NOT NULL,
[RefObjID] [int] NOT NULL,
[HP] [int] NOT NULL,
[MakeDate] [datetime] NOT NULL,
[State] [smallint] NOT NULL
) ON [PRIMARY]

GO

ALTER TABLE [dbo].[_SiegeFortressStruct] ADD DEFAULT (0) FOR [State]
GO

ALTER TABLE [dbo].[_SiegeFortressStruct] WITH NOCHECK ADD CONSTRAINT [FK__SiegeFortressStruct__SiegeFortress] FOREIGN KEY([FortressID])
REFERENCES [dbo].[_SiegeFortress] ([FortressID])
GO

ALTER TABLE [dbo].[_SiegeFortressStruct] CHECK CONSTRAINT [FK__SiegeFortressStruct__SiegeFortress]
GO

[™Dev Microsoft™]

$$