I can't see foreign keys of my tables through user interface when clicking on table, also CREATE code isn't correct. MS SQL 2008 RC2. Can you please fix it?
sorry for my english :P
CREATE TABLE "Questions" (
"ID" INT NOT NULL PRIMARY KEY IDENTITY,
"ID_Topic" INT NOT NULL,
"Type" INT NOT NULL,
"Name" NCHAR(255) NOT NULL,
"Text" NTEXT NOT NULL,
"FreeAnswer" BIT NOT NULL DEFAULT '0'
);
CREATE TABLE "Multimedia" (
"ID_Question" INT NOT NULL,
"Multimedia" VARBINARY NOT NULL,
);
alter table Multimedia ADD FOREIGN KEY (ID_Question) REFERENCES Questions(id) ON DELETE CASCADE;