Interested to Buy Any Domain ? << Click Here >> for more details...
If we have n no of columns in a table, can we add new
column in that table with not null constraint?
- 2 Answers
- 5889 Views
- I also Faced
- E-Mail Answers
Answer Posted / chandan kumar
If table is empty (means no records are there) then we can
add the constraint.
alter table tablename add (col_name datatype not null)
| Is This Answer Correct ? | 6 Yes | 2 No |
Post New Answer View All Answers
What is indexing in sql and its types?
What is the size of partition table?
what are the other commands to know the structure of table using mysql commands except explain command? : Sql dba
Does truncate free space?
Write a program that shows the usage of while loop to calculate the average of user entered numbers and entry of more numbers are stopped by entering number 0?
How to use transactions efficiently : transact sql
In a distributed database system, can we execute two queries simultaneously?
Explain the the update statement in sql?
Name some usages of database trigger?
What is left join in sql?
How many types of normalization are there?
What is difference between function and trigger?
What is the process of debugging?
explain the difference between delete , truncate and drop commands? : Sql dba
what is difference between delete and truncate commands? : Sql dba
