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...

What are the pre requisites?

Answer Posted / guest

I. to modify datatype of a column ?
ii. to add a column with NOT NULL constraint ?

To Modify the datatype of a column the column must be empty.

To add a column with NOT NULL constrain, the table must be
empty.

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is difference between inner join and self join?

1084


what are the authentication modes in sql server? : Sql dba

1060


what is the difference between char_length and length? : Sql dba

1044


What is sql analyzer?

1015


What are the types of index in sql?

1069


which tcp/ip port does sql server run on? : Sql dba

1026


What are the different ddl commands in sql?

1166


Why we use cross join?

952


How do I tune a sql query?

974


What are types of exception?

922


How do I restart sql?

970


What is database white box testing and black box testing?

1109


Which tcp/ip port does sql server run on? How can it be changed? : Sql dba

1000


Do prepared statements prevent sql injection?

949


How to get each name only once from an employee table?

1114