Thursday 19 December 2013

Create table with Foriegn key

CREATE TABLE Users
(
Id int Primary key,
UserName varchar(250),
Group_id int,
AppName varchar(250),
URL varchar(250),
CONSTRAINT fk_Users_List FOREIGN KEY (Group_id)
REFERENCES Group(id)
)

No comments:

Post a Comment