Updatable SQL 2000 partitioned view not updatable in Access

G

Guest

According to Access 2003's help files, SQL Server partitioned views that are
updatable in SQL Server are supposed to be updatable in MS Access.

However...

I have two tables with Identity primary keys that are identical - except for
a single Bit field that defaults to 0 or 1 depending on the table, that is
used to partition the view.

In SQL Enterprise Manager, the view is updatable. In Access, the view is
not updatable. How do I get Access to accept this view as updatable?

The view is:
SELECT *
FROM MH.dbo.tbl_Product_Gown_UArc
UNION ALL
SELECT *
FROM tbl_Product_Gown_Arc

The table definition(s) are as follows, differing only on the constraints
and defaults of the Archived bit field:

CREATE TABLE [dbo].[tbl_Product_Gown_UArc] (
[Gown#] [int] IDENTITY (1, 1) NOT NULL ,
[StyleCode] [varchar] (15) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ,
[Category#] [int] NULL ,
[GownStyle#] [int] NULL ,
[Designer] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[Cap2] [bit] NOT NULL ,
[DesignDate] [datetime] NULL ,
[Description] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ,
[Component#] [int] NOT NULL ,
[Current] [bit] NOT NULL ,
[Comment] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[MaterialCost] [money] NOT NULL ,
[LabourCost] [money] NOT NULL ,
[ExtLabourCost] [money] NOT NULL ,
[TotalTime] [real] NOT NULL ,
[OverheadAmt] [money] NOT NULL ,
[MTOLabourCost] [money] NOT NULL ,
[MTOExtLabourCost] [money] NOT NULL ,
[MTOTotalTime] [real] NOT NULL ,
[MTOOverheadAmt] [money] NOT NULL ,
[MTMLabourCost] [money] NOT NULL ,
[MTMExtLabourCost] [money] NOT NULL ,
[MTMTotalTime] [real] NOT NULL ,
[MTMOverheadAmt] [money] NOT NULL ,
[OPMargin] [money] NULL ,
[Wholesale] [money] NOT NULL ,
[Stock] [money] NOT NULL ,
[RecMTM] [money] NOT NULL ,
[RecMTO] [money] NOT NULL ,
[MTO] [money] NOT NULL ,
[MTM] [money] NOT NULL ,
[RRP] [money] NOT NULL ,
[ManInstructions] [text] COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[Locked] [bit] NOT NULL ,
[IsRTW] [bit] NOT NULL ,
[RTWMaker] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[RTWCost] [money] NOT NULL ,
[RTWRange] [int] NULL ,
[Archive] [bit] NOT NULL ,
[DoNotArchive] [bit] NOT NULL ,
[Archived] [bit] NOT NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO

ALTER TABLE [dbo].[tbl_Product_Gown_UArc] ADD
CONSTRAINT [DF_tbl_Product_Gown_Cap2] DEFAULT (0) FOR [Cap2],
CONSTRAINT [DF__tbl_Produ__Curre__6E01572D] DEFAULT (1) FOR [Current],
CONSTRAINT [DF__tbl_Produ__Mater__6EF57B66] DEFAULT (0) FOR [MaterialCost],
CONSTRAINT [DF__tbl_Produ__Labou__6FE99F9F] DEFAULT (0) FOR [LabourCost],
CONSTRAINT [DF__tbl_Produ__ExtLa__70DDC3D8] DEFAULT (0) FOR [ExtLabourCost],
CONSTRAINT [DF__tbl_Produ__Total__71D1E811] DEFAULT (0) FOR [TotalTime],
CONSTRAINT [DF__tbl_Produ__Overh__72C60C4A] DEFAULT (0) FOR [OverheadAmt],
CONSTRAINT [DF_tbl_Product_Gown_MTMLabourCost1] DEFAULT (0) FOR
[MTOLabourCost],
CONSTRAINT [DF_tbl_Product_Gown_MTMExtLabourCost1] DEFAULT (0) FOR
[MTOExtLabourCost],
CONSTRAINT [DF_tbl_Product_Gown_MTMTotalTime1] DEFAULT (0) FOR
[MTOTotalTime],
CONSTRAINT [DF_tbl_Product_Gown_MTMOverheadAmt1] DEFAULT (0) FOR
[MTOOverheadAmt],
CONSTRAINT [DF__tbl_Produ__MTMLa__73BA3083] DEFAULT (0) FOR [MTMLabourCost],
CONSTRAINT [DF__tbl_Produ__MTMEx__74AE54BC] DEFAULT (0) FOR
[MTMExtLabourCost],
CONSTRAINT [DF__tbl_Produ__MTMTo__75A278F5] DEFAULT (0) FOR [MTMTotalTime],
CONSTRAINT [DF__tbl_Produ__MTMOv__76969D2E] DEFAULT (0) FOR [MTMOverheadAmt],
CONSTRAINT [DF__tbl_Produ__OPMar__778AC167] DEFAULT (0) FOR [OPMargin],
CONSTRAINT [DF__tbl_Produ__Whole__787EE5A0] DEFAULT (0) FOR [Wholesale],
CONSTRAINT [DF__tbl_Produ__Stock__797309D9] DEFAULT (0) FOR [Stock],
CONSTRAINT [DF__tbl_Produ__RecMT__7A672E12] DEFAULT (0) FOR [RecMTM],
CONSTRAINT [DF_tbl_Product_Gown_RecMTM1] DEFAULT (0) FOR [RecMTO],
CONSTRAINT [DF__tbl_Product__MTO__7B5B524B] DEFAULT (0) FOR [MTO],
CONSTRAINT [DF__tbl_Product__MTM__7C4F7684] DEFAULT (0) FOR [MTM],
CONSTRAINT [DF_tbl_Product_Gown_RRP] DEFAULT (0) FOR [RRP],
CONSTRAINT [DF_tbl_Product_Gown_Locked] DEFAULT (1) FOR [Locked],
CONSTRAINT [DF_tbl_Product_Gown_IsRTW] DEFAULT (0) FOR [IsRTW],
CONSTRAINT [DF_tbl_Product_Gown_RTWCost] DEFAULT (0) FOR [RTWCost],
CONSTRAINT [DF_tbl_Product_Gown_Archive] DEFAULT (0) FOR [Archive],
CONSTRAINT [DF_tbl_Product_Gown_DoNotArchive] DEFAULT (0) FOR [DoNotArchive],
CONSTRAINT [DF_tbl_Product_Gown_Archive1] DEFAULT (0) FOR [Archived],
CONSTRAINT [PK_tbl_Product_Gown] PRIMARY KEY NONCLUSTERED
(
[Gown#]
) ON [PRIMARY] ,
CONSTRAINT [CK_tbl_Product_Gown_Archived] CHECK ([Archived] = 0)
GO
 
M

Michel Walsh

The UNION queries are not updateable in Jet, in any circumstances. Note that
Jet does not have partitioned tables..

Vanderghast, Access MVP

Monty said:
According to Access 2003's help files, SQL Server partitioned views that
are
updatable in SQL Server are supposed to be updatable in MS Access.

However...

I have two tables with Identity primary keys that are identical - except
for
a single Bit field that defaults to 0 or 1 depending on the table, that is
used to partition the view.

In SQL Enterprise Manager, the view is updatable. In Access, the view is
not updatable. How do I get Access to accept this view as updatable?

The view is:
SELECT *
FROM MH.dbo.tbl_Product_Gown_UArc
UNION ALL
SELECT *
FROM tbl_Product_Gown_Arc

The table definition(s) are as follows, differing only on the constraints
and defaults of the Archived bit field:

CREATE TABLE [dbo].[tbl_Product_Gown_UArc] (
[Gown#] [int] IDENTITY (1, 1) NOT NULL ,
[StyleCode] [varchar] (15) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ,
[Category#] [int] NULL ,
[GownStyle#] [int] NULL ,
[Designer] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[Cap2] [bit] NOT NULL ,
[DesignDate] [datetime] NULL ,
[Description] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NOT
NULL ,
[Component#] [int] NOT NULL ,
[Current] [bit] NOT NULL ,
[Comment] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[MaterialCost] [money] NOT NULL ,
[LabourCost] [money] NOT NULL ,
[ExtLabourCost] [money] NOT NULL ,
[TotalTime] [real] NOT NULL ,
[OverheadAmt] [money] NOT NULL ,
[MTOLabourCost] [money] NOT NULL ,
[MTOExtLabourCost] [money] NOT NULL ,
[MTOTotalTime] [real] NOT NULL ,
[MTOOverheadAmt] [money] NOT NULL ,
[MTMLabourCost] [money] NOT NULL ,
[MTMExtLabourCost] [money] NOT NULL ,
[MTMTotalTime] [real] NOT NULL ,
[MTMOverheadAmt] [money] NOT NULL ,
[OPMargin] [money] NULL ,
[Wholesale] [money] NOT NULL ,
[Stock] [money] NOT NULL ,
[RecMTM] [money] NOT NULL ,
[RecMTO] [money] NOT NULL ,
[MTO] [money] NOT NULL ,
[MTM] [money] NOT NULL ,
[RRP] [money] NOT NULL ,
[ManInstructions] [text] COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[Locked] [bit] NOT NULL ,
[IsRTW] [bit] NOT NULL ,
[RTWMaker] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[RTWCost] [money] NOT NULL ,
[RTWRange] [int] NULL ,
[Archive] [bit] NOT NULL ,
[DoNotArchive] [bit] NOT NULL ,
[Archived] [bit] NOT NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO

ALTER TABLE [dbo].[tbl_Product_Gown_UArc] ADD
CONSTRAINT [DF_tbl_Product_Gown_Cap2] DEFAULT (0) FOR [Cap2],
CONSTRAINT [DF__tbl_Produ__Curre__6E01572D] DEFAULT (1) FOR [Current],
CONSTRAINT [DF__tbl_Produ__Mater__6EF57B66] DEFAULT (0) FOR
[MaterialCost],
CONSTRAINT [DF__tbl_Produ__Labou__6FE99F9F] DEFAULT (0) FOR [LabourCost],
CONSTRAINT [DF__tbl_Produ__ExtLa__70DDC3D8] DEFAULT (0) FOR
[ExtLabourCost],
CONSTRAINT [DF__tbl_Produ__Total__71D1E811] DEFAULT (0) FOR [TotalTime],
CONSTRAINT [DF__tbl_Produ__Overh__72C60C4A] DEFAULT (0) FOR [OverheadAmt],
CONSTRAINT [DF_tbl_Product_Gown_MTMLabourCost1] DEFAULT (0) FOR
[MTOLabourCost],
CONSTRAINT [DF_tbl_Product_Gown_MTMExtLabourCost1] DEFAULT (0) FOR
[MTOExtLabourCost],
CONSTRAINT [DF_tbl_Product_Gown_MTMTotalTime1] DEFAULT (0) FOR
[MTOTotalTime],
CONSTRAINT [DF_tbl_Product_Gown_MTMOverheadAmt1] DEFAULT (0) FOR
[MTOOverheadAmt],
CONSTRAINT [DF__tbl_Produ__MTMLa__73BA3083] DEFAULT (0) FOR
[MTMLabourCost],
CONSTRAINT [DF__tbl_Produ__MTMEx__74AE54BC] DEFAULT (0) FOR
[MTMExtLabourCost],
CONSTRAINT [DF__tbl_Produ__MTMTo__75A278F5] DEFAULT (0) FOR
[MTMTotalTime],
CONSTRAINT [DF__tbl_Produ__MTMOv__76969D2E] DEFAULT (0) FOR
[MTMOverheadAmt],
CONSTRAINT [DF__tbl_Produ__OPMar__778AC167] DEFAULT (0) FOR [OPMargin],
CONSTRAINT [DF__tbl_Produ__Whole__787EE5A0] DEFAULT (0) FOR [Wholesale],
CONSTRAINT [DF__tbl_Produ__Stock__797309D9] DEFAULT (0) FOR [Stock],
CONSTRAINT [DF__tbl_Produ__RecMT__7A672E12] DEFAULT (0) FOR [RecMTM],
CONSTRAINT [DF_tbl_Product_Gown_RecMTM1] DEFAULT (0) FOR [RecMTO],
CONSTRAINT [DF__tbl_Product__MTO__7B5B524B] DEFAULT (0) FOR [MTO],
CONSTRAINT [DF__tbl_Product__MTM__7C4F7684] DEFAULT (0) FOR [MTM],
CONSTRAINT [DF_tbl_Product_Gown_RRP] DEFAULT (0) FOR [RRP],
CONSTRAINT [DF_tbl_Product_Gown_Locked] DEFAULT (1) FOR [Locked],
CONSTRAINT [DF_tbl_Product_Gown_IsRTW] DEFAULT (0) FOR [IsRTW],
CONSTRAINT [DF_tbl_Product_Gown_RTWCost] DEFAULT (0) FOR [RTWCost],
CONSTRAINT [DF_tbl_Product_Gown_Archive] DEFAULT (0) FOR [Archive],
CONSTRAINT [DF_tbl_Product_Gown_DoNotArchive] DEFAULT (0) FOR
[DoNotArchive],
CONSTRAINT [DF_tbl_Product_Gown_Archive1] DEFAULT (0) FOR [Archived],
CONSTRAINT [PK_tbl_Product_Gown] PRIMARY KEY NONCLUSTERED
(
[Gown#]
) ON [PRIMARY] ,
CONSTRAINT [CK_tbl_Product_Gown_Archived] CHECK ([Archived] = 0)
GO
Click to expand...
 
G

Guest

I should have mentioned that I am using an ADP, not an MDB. Jet has nothing
to do with it, the project is connecting directly to the SQL server on which
the view is working updatably, yet Access does not recognise the view as
being updatable as the help files say it should be.

Michel Walsh said:
The UNION queries are not updateable in Jet, in any circumstances. Note that
Jet does not have partitioned tables..

Vanderghast, Access MVP

Monty said:
According to Access 2003's help files, SQL Server partitioned views that
are
updatable in SQL Server are supposed to be updatable in MS Access.

However...

I have two tables with Identity primary keys that are identical - except
for
a single Bit field that defaults to 0 or 1 depending on the table, that is
used to partition the view.

In SQL Enterprise Manager, the view is updatable. In Access, the view is
not updatable. How do I get Access to accept this view as updatable?

The view is:
SELECT *
FROM MH.dbo.tbl_Product_Gown_UArc
UNION ALL
SELECT *
FROM tbl_Product_Gown_Arc

The table definition(s) are as follows, differing only on the constraints
and defaults of the Archived bit field:

CREATE TABLE [dbo].[tbl_Product_Gown_UArc] (
[Gown#] [int] IDENTITY (1, 1) NOT NULL ,
[StyleCode] [varchar] (15) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ,
[Category#] [int] NULL ,
[GownStyle#] [int] NULL ,
[Designer] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[Cap2] [bit] NOT NULL ,
[DesignDate] [datetime] NULL ,
[Description] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NOT
NULL ,
[Component#] [int] NOT NULL ,
[Current] [bit] NOT NULL ,
[Comment] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[MaterialCost] [money] NOT NULL ,
[LabourCost] [money] NOT NULL ,
[ExtLabourCost] [money] NOT NULL ,
[TotalTime] [real] NOT NULL ,
[OverheadAmt] [money] NOT NULL ,
[MTOLabourCost] [money] NOT NULL ,
[MTOExtLabourCost] [money] NOT NULL ,
[MTOTotalTime] [real] NOT NULL ,
[MTOOverheadAmt] [money] NOT NULL ,
[MTMLabourCost] [money] NOT NULL ,
[MTMExtLabourCost] [money] NOT NULL ,
[MTMTotalTime] [real] NOT NULL ,
[MTMOverheadAmt] [money] NOT NULL ,
[OPMargin] [money] NULL ,
[Wholesale] [money] NOT NULL ,
[Stock] [money] NOT NULL ,
[RecMTM] [money] NOT NULL ,
[RecMTO] [money] NOT NULL ,
[MTO] [money] NOT NULL ,
[MTM] [money] NOT NULL ,
[RRP] [money] NOT NULL ,
[ManInstructions] [text] COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[Locked] [bit] NOT NULL ,
[IsRTW] [bit] NOT NULL ,
[RTWMaker] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[RTWCost] [money] NOT NULL ,
[RTWRange] [int] NULL ,
[Archive] [bit] NOT NULL ,
[DoNotArchive] [bit] NOT NULL ,
[Archived] [bit] NOT NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO

ALTER TABLE [dbo].[tbl_Product_Gown_UArc] ADD
CONSTRAINT [DF_tbl_Product_Gown_Cap2] DEFAULT (0) FOR [Cap2],
CONSTRAINT [DF__tbl_Produ__Curre__6E01572D] DEFAULT (1) FOR [Current],
CONSTRAINT [DF__tbl_Produ__Mater__6EF57B66] DEFAULT (0) FOR
[MaterialCost],
CONSTRAINT [DF__tbl_Produ__Labou__6FE99F9F] DEFAULT (0) FOR [LabourCost],
CONSTRAINT [DF__tbl_Produ__ExtLa__70DDC3D8] DEFAULT (0) FOR
[ExtLabourCost],
CONSTRAINT [DF__tbl_Produ__Total__71D1E811] DEFAULT (0) FOR [TotalTime],
CONSTRAINT [DF__tbl_Produ__Overh__72C60C4A] DEFAULT (0) FOR [OverheadAmt],
CONSTRAINT [DF_tbl_Product_Gown_MTMLabourCost1] DEFAULT (0) FOR
[MTOLabourCost],
CONSTRAINT [DF_tbl_Product_Gown_MTMExtLabourCost1] DEFAULT (0) FOR
[MTOExtLabourCost],
CONSTRAINT [DF_tbl_Product_Gown_MTMTotalTime1] DEFAULT (0) FOR
[MTOTotalTime],
CONSTRAINT [DF_tbl_Product_Gown_MTMOverheadAmt1] DEFAULT (0) FOR
[MTOOverheadAmt],
CONSTRAINT [DF__tbl_Produ__MTMLa__73BA3083] DEFAULT (0) FOR
[MTMLabourCost],
CONSTRAINT [DF__tbl_Produ__MTMEx__74AE54BC] DEFAULT (0) FOR
[MTMExtLabourCost],
CONSTRAINT [DF__tbl_Produ__MTMTo__75A278F5] DEFAULT (0) FOR
[MTMTotalTime],
CONSTRAINT [DF__tbl_Produ__MTMOv__76969D2E] DEFAULT (0) FOR
[MTMOverheadAmt],
CONSTRAINT [DF__tbl_Produ__OPMar__778AC167] DEFAULT (0) FOR [OPMargin],
CONSTRAINT [DF__tbl_Produ__Whole__787EE5A0] DEFAULT (0) FOR [Wholesale],
CONSTRAINT [DF__tbl_Produ__Stock__797309D9] DEFAULT (0) FOR [Stock],
CONSTRAINT [DF__tbl_Produ__RecMT__7A672E12] DEFAULT (0) FOR [RecMTM],
CONSTRAINT [DF_tbl_Product_Gown_RecMTM1] DEFAULT (0) FOR [RecMTO],
CONSTRAINT [DF__tbl_Product__MTO__7B5B524B] DEFAULT (0) FOR [MTO],
CONSTRAINT [DF__tbl_Product__MTM__7C4F7684] DEFAULT (0) FOR [MTM],
CONSTRAINT [DF_tbl_Product_Gown_RRP] DEFAULT (0) FOR [RRP],
CONSTRAINT [DF_tbl_Product_Gown_Locked] DEFAULT (1) FOR [Locked],
CONSTRAINT [DF_tbl_Product_Gown_IsRTW] DEFAULT (0) FOR [IsRTW],
CONSTRAINT [DF_tbl_Product_Gown_RTWCost] DEFAULT (0) FOR [RTWCost],
CONSTRAINT [DF_tbl_Product_Gown_Archive] DEFAULT (0) FOR [Archive],
CONSTRAINT [DF_tbl_Product_Gown_DoNotArchive] DEFAULT (0) FOR
[DoNotArchive],
CONSTRAINT [DF_tbl_Product_Gown_Archive1] DEFAULT (0) FOR [Archived],
CONSTRAINT [PK_tbl_Product_Gown] PRIMARY KEY NONCLUSTERED
(
[Gown#]
) ON [PRIMARY] ,
CONSTRAINT [CK_tbl_Product_Gown_Archived] CHECK ([Archived] = 0)
GO
Click to expand...
Click to expand...
 
M

Michel Walsh

Ah, but I am sure it is in the documentation somewhere, you HAVE TO have the
primary key fields present, and that is a sine qua non condition, EVEN if
the query is simply based on a single table ! At least, that was the case
in pre-2007 versions, as far as I remember.


Vanderghast, Access MVP


Monty said:
I should have mentioned that I am using an ADP, not an MDB. Jet has
nothing
to do with it, the project is connecting directly to the SQL server on
which
the view is working updatably, yet Access does not recognise the view as
being updatable as the help files say it should be.

Michel Walsh said:
The UNION queries are not updateable in Jet, in any circumstances. Note
that
Jet does not have partitioned tables..

Vanderghast, Access MVP

Monty said:
According to Access 2003's help files, SQL Server partitioned views
that
are
updatable in SQL Server are supposed to be updatable in MS Access.

However...

I have two tables with Identity primary keys that are identical -
except
for
a single Bit field that defaults to 0 or 1 depending on the table, that
is
used to partition the view.

In SQL Enterprise Manager, the view is updatable. In Access, the view
is
not updatable. How do I get Access to accept this view as updatable?

The view is:
SELECT *
FROM MH.dbo.tbl_Product_Gown_UArc
UNION ALL
SELECT *
FROM tbl_Product_Gown_Arc

The table definition(s) are as follows, differing only on the
constraints
and defaults of the Archived bit field:

CREATE TABLE [dbo].[tbl_Product_Gown_UArc] (
[Gown#] [int] IDENTITY (1, 1) NOT NULL ,
[StyleCode] [varchar] (15) COLLATE SQL_Latin1_General_CP1_CI_AS NOT
NULL ,
[Category#] [int] NULL ,
[GownStyle#] [int] NULL ,
[Designer] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[Cap2] [bit] NOT NULL ,
[DesignDate] [datetime] NULL ,
[Description] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NOT
NULL ,
[Component#] [int] NOT NULL ,
[Current] [bit] NOT NULL ,
[Comment] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[MaterialCost] [money] NOT NULL ,
[LabourCost] [money] NOT NULL ,
[ExtLabourCost] [money] NOT NULL ,
[TotalTime] [real] NOT NULL ,
[OverheadAmt] [money] NOT NULL ,
[MTOLabourCost] [money] NOT NULL ,
[MTOExtLabourCost] [money] NOT NULL ,
[MTOTotalTime] [real] NOT NULL ,
[MTOOverheadAmt] [money] NOT NULL ,
[MTMLabourCost] [money] NOT NULL ,
[MTMExtLabourCost] [money] NOT NULL ,
[MTMTotalTime] [real] NOT NULL ,
[MTMOverheadAmt] [money] NOT NULL ,
[OPMargin] [money] NULL ,
[Wholesale] [money] NOT NULL ,
[Stock] [money] NOT NULL ,
[RecMTM] [money] NOT NULL ,
[RecMTO] [money] NOT NULL ,
[MTO] [money] NOT NULL ,
[MTM] [money] NOT NULL ,
[RRP] [money] NOT NULL ,
[ManInstructions] [text] COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[Locked] [bit] NOT NULL ,
[IsRTW] [bit] NOT NULL ,
[RTWMaker] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[RTWCost] [money] NOT NULL ,
[RTWRange] [int] NULL ,
[Archive] [bit] NOT NULL ,
[DoNotArchive] [bit] NOT NULL ,
[Archived] [bit] NOT NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO

ALTER TABLE [dbo].[tbl_Product_Gown_UArc] ADD
CONSTRAINT [DF_tbl_Product_Gown_Cap2] DEFAULT (0) FOR [Cap2],
CONSTRAINT [DF__tbl_Produ__Curre__6E01572D] DEFAULT (1) FOR [Current],
CONSTRAINT [DF__tbl_Produ__Mater__6EF57B66] DEFAULT (0) FOR
[MaterialCost],
CONSTRAINT [DF__tbl_Produ__Labou__6FE99F9F] DEFAULT (0) FOR
[LabourCost],
CONSTRAINT [DF__tbl_Produ__ExtLa__70DDC3D8] DEFAULT (0) FOR
[ExtLabourCost],
CONSTRAINT [DF__tbl_Produ__Total__71D1E811] DEFAULT (0) FOR
[TotalTime],
CONSTRAINT [DF__tbl_Produ__Overh__72C60C4A] DEFAULT (0) FOR
[OverheadAmt],
CONSTRAINT [DF_tbl_Product_Gown_MTMLabourCost1] DEFAULT (0) FOR
[MTOLabourCost],
CONSTRAINT [DF_tbl_Product_Gown_MTMExtLabourCost1] DEFAULT (0) FOR
[MTOExtLabourCost],
CONSTRAINT [DF_tbl_Product_Gown_MTMTotalTime1] DEFAULT (0) FOR
[MTOTotalTime],
CONSTRAINT [DF_tbl_Product_Gown_MTMOverheadAmt1] DEFAULT (0) FOR
[MTOOverheadAmt],
CONSTRAINT [DF__tbl_Produ__MTMLa__73BA3083] DEFAULT (0) FOR
[MTMLabourCost],
CONSTRAINT [DF__tbl_Produ__MTMEx__74AE54BC] DEFAULT (0) FOR
[MTMExtLabourCost],
CONSTRAINT [DF__tbl_Produ__MTMTo__75A278F5] DEFAULT (0) FOR
[MTMTotalTime],
CONSTRAINT [DF__tbl_Produ__MTMOv__76969D2E] DEFAULT (0) FOR
[MTMOverheadAmt],
CONSTRAINT [DF__tbl_Produ__OPMar__778AC167] DEFAULT (0) FOR [OPMargin],
CONSTRAINT [DF__tbl_Produ__Whole__787EE5A0] DEFAULT (0) FOR
[Wholesale],
CONSTRAINT [DF__tbl_Produ__Stock__797309D9] DEFAULT (0) FOR [Stock],
CONSTRAINT [DF__tbl_Produ__RecMT__7A672E12] DEFAULT (0) FOR [RecMTM],
CONSTRAINT [DF_tbl_Product_Gown_RecMTM1] DEFAULT (0) FOR [RecMTO],
CONSTRAINT [DF__tbl_Product__MTO__7B5B524B] DEFAULT (0) FOR [MTO],
CONSTRAINT [DF__tbl_Product__MTM__7C4F7684] DEFAULT (0) FOR [MTM],
CONSTRAINT [DF_tbl_Product_Gown_RRP] DEFAULT (0) FOR [RRP],
CONSTRAINT [DF_tbl_Product_Gown_Locked] DEFAULT (1) FOR [Locked],
CONSTRAINT [DF_tbl_Product_Gown_IsRTW] DEFAULT (0) FOR [IsRTW],
CONSTRAINT [DF_tbl_Product_Gown_RTWCost] DEFAULT (0) FOR [RTWCost],
CONSTRAINT [DF_tbl_Product_Gown_Archive] DEFAULT (0) FOR [Archive],
CONSTRAINT [DF_tbl_Product_Gown_DoNotArchive] DEFAULT (0) FOR
[DoNotArchive],
CONSTRAINT [DF_tbl_Product_Gown_Archive1] DEFAULT (0) FOR [Archived],
CONSTRAINT [PK_tbl_Product_Gown] PRIMARY KEY NONCLUSTERED
(
[Gown#]
) ON [PRIMARY] ,
CONSTRAINT [CK_tbl_Product_Gown_Archived] CHECK ([Archived] = 0)
GO
Click to expand...
Click to expand...
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

SQL Server Error: 8629 2
6 digits Unique Number 6
Fast SQL Server Stored Procedure runs slow in VB.NET 4
Why am I getting ForeignKeyConstraint requires child key value error? 12
System.Data.Common.DbDataAdapter Bug. 1
DataGrid does not recognize that ID is an identity 7
Not every data are treated equally 6
"IF" test in SP evals to True and False at same time using DataAdapter.FillSchema() 1

Top