لدي ملف وضعت به الـ schema الكاملة لقاعدة البيانات
ما سبب هذا الخطأ :
CREATE VIEW MUST BE THE FIRST STATEMENT IN THE QUERY BATCH
و هذا هو ملف الـ schema
CREATE TABLE USERS( user_id int IDENTITY(1,1) NOT NULL, username nvarchar(255) NOT NULL, password nvarchar(255) NULL, Locked bit NULL, deleted bit NULL, permissions nchar(100) NULL, CONSTRAINT PK__USERS__7E6CC920 PRIMARY KEY ( user_id ASC ) ) ; CREATE TABLE GROUPS( group_id int IDENTITY(1,1) NOT NULL, group_name nvarchar(255) NOT NULL, deleted bit NULL, permissoins nchar(100) NULL, CONSTRAINT PK__GROUPS__7C8480AE PRIMARY KEY CLUSTERED ( group_id ASC ) ) ; CREATE TABLE USERS_GROUP( user_id int NULL, group_id int NULL ) ; ALTER TABLE USERS_GROUP WITH CHECK ADD CONSTRAINT users_group_fk_1 FOREIGN KEY(user_id) REFERENCES USERS (user_id) ; ALTER TABLE USERS_GROUP WITH CHECK ADD CONSTRAINT users_group_fk_2 FOREIGN KEY(group_id) REFERENCES GROUPS (group_id) ; CREATE VIEW V_USER_GROUP AS SELECT USERS.user_id, USERS.username, USERS.password, USERS.Locked, GROUPS.group_id, GROUPS.group_name, USERS.deleted AS udeleted, GROUPS.deleted AS gdeleted FROM USERS INNER JOIN USERS_GROUP ON USERS.user_id = USERS_GROUP.user_id INNER JOIN GROUPS ON USERS_GROUP.group_id = GROUPS.group_id ;
أرجو المساعدة