p2p.wrox.com Forums

Need to download code?

View our list of code downloads.


  Return to Index  

aspdotnet_website_programming thread: DB Incomplete


Message #1 by "Ricardo Barros Figueira" <RBFigueira@m...> on Tue, 11 Mar 2003 10:56:52 -0000
Friends,

In the DB Diagram book the Accounts tables have some 
CONSTRAINTs/CLUSTERED.
For example:

BOOK Diagram:
- Accounts_Users have one (PK UserID)


On SQLSERVER DB:

ALTER TABLE [dbo].[Accounts_Users] WITH NOCHECK ADD
	CONSTRAINT [PK_Accounts_Users] PRIMARY KEY  CLUSTERED
	(
		[UserID]
	)  ON [PRIMARY]
GO

OK is there :)

BOOK Diagram:
- Accounts_UserRoles have two (PK) RoleID and UserID

On SQLSERVER DB:
Nothing !!!!!!

There are other tables (Accounts) that have in the book (diagrams) 
CONSTRAINTs and in the real database (Sqlserver) they dont !!!

Can anyone put here the complete [Accounts tables] script (*.sql) !!

Ok, i can make that on the DB BUT i would like to see the original 
script :)

Best regards,
Ricardo Figueira (RBFIGUEIRA)







  Return to Index