Results 1 to 6 of 6

Thread: Create table + index + primary

Threaded View

  1. 12-17-2006, 10:00 PM #2
    rmiao
    rmiao is offline Registered User
    Join Date
    Sep 2002
    Posts
    5,938
    CREATE TABLE [dbo].[Users] (
    [id_Users] [int] NOT NULL PRIMARY KEY clustered,
    [Name] [nvarchar] (100) NULL,
    [Serial] [nvarchar] (100) NULL unique,
    ) ON [PRIMARY]


    CREATE TABLE [dbo].[UsersExtra] (
    [id_Users] [int] NOT NULL references [users].[id_users] on delete cascade
    ) ON [PRIMARY]


    You can find syntax in books online.
    Last edited by rmiao; 12-17-2006 at 10:02 PM.
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules