Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

While creating a table, by mistake you have given size of one
field as 10. But as per requirement size should be 8. What is
your next step?

Answer Posted / rahul

If table is empty then we alter this column to any length,
but if some data got inserted into the table then we can
also decrease the column length upto largest data size
available in that perticulat column.

Is This Answer Correct ?    1 Yes 5 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is explain in db2?

1012


Define db2 and its databases?

1053


What is dbrm library?

1047


What is the difference between plan and package in db2?

1106


Is the primary key a clustered index?

1141


what is a corelated subquerry?

1120


What is with ur in db2?

1302


What is the meaning concurrency in the db2 database?

1108


Where do you specify them?

1271


How to rename a table in DB2 ?

1086


What does db2 stand for?

1019


How do you find the maximum value in a column in db2?

1100


What is data manager?

1045


Is db2 a mainframe?

1041


Explain in detail about buffer manager and its functionalities?

1063