Sql Backup And FTP

Welcome Guest Search | Active Topics | Log In | Register
New Topic Post Reply
Scripting data only for one table also create the indexes for that table Options · View
Guest
#1 Posted : Thursday, June 09, 2011 7:33:45 PM Quote
Rank: Guest

Groups:

Joined: 8/10/2009
Posts: 725
Hello,

I'm using 0.9.2 and while I'm trying to script the data for one table only with other options checked it's still included the CREATE NONCLUSTERED INDEX and CLUSTER INDEX in the script (listed below).

I think that's a bug but am I missing some configuration somewhere to turn that off?

Thank you.



--Table dbo.ZONES

USE [HOST]
GO

INSERT INTO [dbo].[ZONES] ([ZONE_KEY], [Zone_No], [Price Table], [Zone Description], [ZoneType], [Store_No], [RowVersion])
VALUES (10000001, 1, NULL, N'ZONE 1', N'R', 0, CAST(0x00000000001fdca6 AS timestamp))

GO
INSERT INTO [dbo].[ZONES] ([ZONE_KEY], [Zone_No], [Price Table], [Zone Description], [ZoneType], [Store_No], [RowVersion])
VALUES (30000001, 2, 30000003, N'ZONE 1', N'P', 0, CAST(0x00000000002d8b2b AS timestamp))

GO

--Indexes of table dbo.ZONES
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE NONCLUSTERED INDEX [IXPRICETABLE] ON [dbo].[ZONES] ([Price Table])
GO
CREATE NONCLUSTERED INDEX [IXZONETYPE] ON [dbo].[ZONES] ([ZoneType])
GO
ALTER TABLE [dbo].[ZONES] ADD CONSTRAINT [PK_ZONES_IXAUTOINC] PRIMARY KEY CLUSTERED ([ZONE_KEY])
GO
mikeshilov
#2 Posted : Friday, June 10, 2011 5:47:41 AM Quote
Rank: Administration

Groups: Administrators

Joined: 8/12/2009
Posts: 271
thank you for reporting this, we'll look into it
Quick Reply Show Quick Reply
New Topic Post Reply
Forum Jump  
You can post new topics in this forum.
You can reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You can create polls in this forum.
You can vote in polls in this forum.