Any help appreciated,
Keith
---------------
if exists (select * from dbo.sysobjects where id =
object_id(N'[dbo].[FK_ACCESS_ACCESS_PATH]') and OBJECTPROPERTY(id,
N'IsForeignKey') = 1)
ALTER TABLE [dbo].[ACCESS] DROP CONSTRAINT FK_ACCESS_ACCESS_PATH
GO
if exists (select * from dbo.sysobjects where id =
object_id(N'[dbo].[FK_ACCESS_USER]') and OBJECTPROPERTY(id,
N'IsForeignKey') = 1)
ALTER TABLE [dbo].[ACCESS] DROP CONSTRAINT FK_ACCESS_USER
GO
if exists (select * from dbo.sysobjects where id =
object_id(N'[dbo].[ACCESS]') and OBJECTPROPERTY(id, N'IsUserTable') =
1)
drop table [dbo].[ACCESS]
GO
if exists (select * from dbo.sysobjects where id =
object_id(N'[dbo].[ACCESS_PATH]') and OBJECTPROPERTY(id,
N'IsUserTable') = 1)
drop table [dbo].[ACCESS_PATH]
GO
if exists (select * from dbo.sysobjects where id =
object_id(N'[dbo].[USER]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[USER]
GO
CREATE TABLE [dbo].[ACCESS] (
[user_id] [int] NOT NULL ,
[access_id] [int] NOT NULL
) ON [PRIMARY]
GO
CREATE TABLE [dbo].[ACCESS_PATH] (
[access_id] [int] IDENTITY (1, 1) NOT NULL ,
[path] [varchar] (256) COLLATE SQL_Latin1_General_CP1_CI_AS NULL
) ON [PRIMARY]
GO
CREATE TABLE [dbo].[USER] (
[user_id] [int] IDENTITY (1, 1) NOT NULL ,
[fname] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[lname] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[ACCESS] WITH NOCHECK ADD
CONSTRAINT [PK_ACCESS] PRIMARY KEY CLUSTERED
(
[user_id],
[access_id]
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[ACCESS_PATH] WITH NOCHECK ADD
CONSTRAINT [PK_ACCESS_PATH] PRIMARY KEY CLUSTERED
(
[access_id]
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[USER] WITH NOCHECK ADD
CONSTRAINT [PK_USER] PRIMARY KEY CLUSTERED
(
[user_id]
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[ACCESS] ADD
CONSTRAINT [FK_ACCESS_ACCESS_PATH] FOREIGN KEY
(
[access_id]
) REFERENCES [dbo].[ACCESS_PATH] (
[access_id]
),
CONSTRAINT [FK_ACCESS_USER] FOREIGN KEY
(
[user_id]
) REFERENCES [dbo].[USER] (
[user_id]
)
GO
Thanks for the help!!
chie...@yahoo.com (KeithR) wrote in message news:<b2f93c8c.02041...@posting.google.com>...