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
What is difference between inner join and self join?
what are the authentication modes in sql server? : Sql dba
what is the difference between char_length and length? : Sql dba
What is sql analyzer?
What are the types of index in sql?
which tcp/ip port does sql server run on? : Sql dba
What are the different ddl commands in sql?
Why we use cross join?
How do I tune a sql query?
What are types of exception?
How do I restart sql?
What is database white box testing and black box testing?
Which tcp/ip port does sql server run on? How can it be changed? : Sql dba
Do prepared statements prevent sql injection?
How to get each name only once from an employee table?