GeekInterview.com
   Home |  Tech FAQ  |   Interview Questions |  Placement Papers |  Tech Articles |  Learn |  Freelance Projects |  Online Testing |  Geeks Talk |  Job Postings |  Knowledge Base | Site Search |  Add/Ask Question

  GeekInterview.com  >  Interview Questions  >  Peoplesoft  >  PS Admin

 Print  |  
Question:   When you alter a table (adding few fields or deleting fields from
record)with out lossing the data what you will do?




April 04, 2008 17:38:03 #2
 Zoheir   Member Since: April 2008    Total Comments: 1 

RE: When you alter a table (adding few fields or deleting fields from record)with out lossing the data what you will do?
 
When you build the table, check the Alter table option, and in options under Alter tables tab, select alter with table rename.
Once you build the project, then run the script to alter the table
This will keep all the data.
     

 

Back To Question