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
- 5982 Views
- I also Faced
- E-Mail Answers
Answer Posted / 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';
| Is This Answer Correct ? | 7 Yes | 1 No |
Post New Answer View All Answers
Which sorts rows in sql?
Which normal form is best?
What are the key differences between SQL and PL SQL?
What are conditional predicates?
What is sequence in sql?
Explain what is rdbms?
what is a relationship and what are they? : Sql dba
What is the syntax and use of the coalesce function?
What is dense_rank in sql?
How do temporal tables work?
What is varchar sql?
What is union and union all keyword in sql and what are their differences?
What are the different dcl commands in sql?
What is cold data?
What is database sql?
