drdb2
作者drdb2·2011-11-05 01:42
系统工程师·se

Tip: create an old version v8 sample database

字数 778阅读 969评论 0赞 0
Please see the example:
/home/db2admin> db2sampl -v8 -dbpath /home/db2admin/sample8 -name sample8 -verbose  
  Creating database "sample8" on path "/home/db2admin/sample8"...
  Connecting to database "sample8"...
  Creating tables and data in schema "DB2ADMIN"...
  'db2sampl' processing complete.
Note: the tables do not have PK; you may manually create them using:
ALTER TABLE "ORG" ADD PRIMARY KEY ("DEPTNUMB");
ALTER TABLE "STAFF" ADD PRIMARY KEY ("ID");
ALTER TABLE "DEPARTMENT" ADD PRIMARY KEY ("DEPTNO");
ALTER TABLE "EMPLOYEE" ADD PRIMARY KEY ("EMPNO");
ALTER TABLE "PROJECT" ADD PRIMARY KEY ("PROJNO");
ALTER TABLE "EMP_PHOTO" ADD PRIMARY KEY ("EMPNO", "PHOTO_FORMAT");
ALTER TABLE "EMP_RESUME" ADD PRIMARY KEY ("EMPNO", "RESUME_FORMAT");

如果觉得我的文章对您有用,请点赞。您的支持将鼓励我继续创作!

0

添加新评论0 条评论

Ctrl+Enter 发表

作者其他文章

相关资料

X社区推广