constraint Qna 관련 답변 10 페이지
데이터 베이스 잘하시는분ㅎ
... null constraint dept_dept_no_PK primary key(dept_no) )... add constraint dept_dept_tel_UQ unique(dept_tel) insert... drop constraint dept_dept_tel_UQ alter table dept add...
태그:
오라클 sql 궁금한 점이 있어서 질문...
... (1) empno number(10) primary key (2) constraint emppk primary key(empno) 2. 괄호 안의 숫자가... (1) empno number(10) primary key (2) constraint emppk primary key(empno) => 1번의 경우 PK명이...
태그:
오라클 데이터베이스 테이블 만드는법좀..
... N')), CONSTRAINT KEYN5 FOREIGN KEY(MEMBERID,TRAVELID) REFERENCES TRAVEL(MEMBERID,TRAVELID), CONSTRAINT... SYSDATE, CONSTRAINT KEYN4 PRIMARY KEY(TRAVELID...
sql 초보....
... int, constraint pk_course primary key(course_id) )... alter table Cours add constraint pk_course foreign... add constraint pk_course foreign key(course_id)...
태그:
데이터베이스 고수님들 도와주세요,ㅠ
... null constraint dept_dept_no_PK primary key(dept_no) )... add constraint dept_dept_tel_UQ unique(dept_tel) insert... drop constraint dept_dept_tel_UQ alter table dept add...
태그:
미시경제학
... budget constraint foa consumer with income "I" where... show the budget constraint if he or she participates... budget constraint foa consumer with income "I" where...
태그:
급해요~ 아침 7시까진 완성해야하는데...
... (50) CONSTRAINT nate_on_id PRIMARY KEY, PASSWORD... DATE CONSTRAINT T_FRIENDS_PK PRIMARY KEY(ID, FRIEND_ID)... (50) CONSTRAINT nate_on_id PRIMARY KEY, PASSWORD VARCHAR2...
태그:
MySQL 외래키 지정 하는 것 좀...
... ALTER TABLE EMPLOYEE ADD CONSTRAINT FOREIGN KEY(Super_ssn) REFERENCES EMPLOYEE(Ssn); ALTER TABLE WORKS_ON ADD CONSTRAINT... ALTER TABLE WORKS_ON ADD CONSTRAINT FOREIGN KEY(Essn)...
태그:
해결법 있나요?
System.Data.SqlClient.SqlException: 'Violation of PRIMARY KEY constraint 'PK__고객정보__986D3EE64B7FF786'. Cannot insert duplicate key in object 'dbo.고객정보'. The...
태그:
의사 SQL - DB 테이블 생성
... ㅠㅠ CREATE TABLE doctor (docNO NUMBER(4) CONSTRAINT doc_no_pk PRIMARY KEY, NAME... (10) ,CONSTRAINT PK_DOCTOR PRIMARY KEY (DNO) ) ; COMMENT ON TABLE DOCTOR IS '의사...
태그: