Author Topic: Q) What is the difference between the three batch files?  (Read 123 times)

0 Members and 1 Guest are viewing this topic.

Offline Corps

  • Sr. Member
  • *
  • Posts: 274
  • Karma: +0/-0
    • View Profile
Q) What is the difference between the three batch files?
« on: January 06, 2009, 07:21:24 AM »
Q) What is the difference between the three batch files?

INSTALLRECRUITMENTDB.BAT
INSTALLRECRUITMENTDBFORLESSON5.BAT
and INSTALLRECRUITMENTDBWITHOUTCONSTRAINT.BAT


Answer)  INSTALLRECRUITMENTDB.BAT: would create the Recruitment database with constraints. All the tables will be created with primary key and foreign key relations.
INSTALLRECRUITMENTDBFORLESSON5.BAT: would drop the existing recruitment database and recreate it without any objects. This is required because we are creating tables in Lesson 5. If the tables already exist, an error would be generated.
INSTALLRECRUITMENTDBWITHOUTCONSTRAINT.BAT: would drop the existing recruitment database and recreate it without any constraints. All the tables will be created but they would not have primary key and foreign key relations. Any table can be dropped. Also, you can create indexes and constrains on the existing tables.

Techronnati | where technology never sleeps

Q) What is the difference between the three batch files?
« on: January 06, 2009, 07:21:24 AM »

Mountain View

 

Related Topics

  Subject / Started by Replies Last post
1 Replies
153 Views
Last post November 03, 2008, 11:35:53 PM
by Corps
2 Replies
157 Views
Last post November 03, 2008, 11:45:49 PM
by CyborgRepublic
0 Replies
62 Views
Last post January 06, 2009, 07:17:48 AM
by rpmolecule
0 Replies
86 Views
Last post September 09, 2014, 09:15:55 AM
by Transformer10
0 Replies
87 Views
Last post March 11, 2015, 08:56:55 AM
by JusticeLeague

Posting Disclaimer: Any individual may post a message in this forum and may do so anonymously. Therefore, the sole author is exclusively and entirely responsible for all opinions in that message. They do not represent the official opinions of Techronnati, its administrators or moderators or the Techronnati Management. Techronnati is merely acting as an impartial conduit for constitutionally protected free speech and is not responsible and will not be held liable for the content of such messages. All images and service logos are trademarks of their respective owners.