SQL_SELECT INTO

SELECT * INTO buyTbl2 FROM buyTbl; --buyTbl을 buyTbl2로 복사
SELECT * FROM buyTbl2;
SELECT * FROM buyTbl;

 

 

 

SELECT userID, prodName INTO buyTbl3 FROM buyTbl; --지정한열만 일부복사
SELECT * FROM buyTbl3;

 

 

그러나 기본키(PK)나 외래키(FK)는 복사되지 않는다.