Answer / srinu

U r correct Chandan.But one thing,what is that is if the
table contains some data at that time syntax for adding new
column to that table with notnull constraint is....

alter table table_name add column_name datatype default
value constraint constraint_name not null;

if we want 2 know which columns have which constraints then
the syntax is

select column_name,constraint_type
from user_cons_columns
where table_name='EMP';

Answer / 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 it important to partition hard disk?

0 Answers  

---

How do I count rows in sql?

0 Answers  

---

How long does it take to learn pl sql?

0 Answers  

---

How do I view stored procedures?

0 Answers  

---

What is a constraint. Types of constraints ?

5 Answers   Accenture, BirlaSoft,

---

write an sql query to find names of employee start with 'a'? : Sql dba

0 Answers  

---

What is a schema? How is it useful in sql servers?

0 Answers  

---

What is the difference between subquery and correlated query?

0 Answers  

---

what is a database lock ? : Sql dba

0 Answers  

---

What is the usage of when clause in trigger?

0 Answers  

---

How can the performance of a trigger be improved?

0 Answers  

---

What are the set operators in sql?

0 Answers  

---