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)