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
- 5744 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
what is foreign key? : Sql dba
What is having clause in sql?
What does pragma mean?
How do you write a complex sql query?
Where the sql database files are stored?
What is before and after trigger?
What is rowid in sql?
What is the max nvarchar size?
What is varray in pl sql?
Suppose a student column has two columns, name and marks. How to get name and marks of the top three students.
What is online transaction processing (oltp)?
Can we commit inside a trigger?
In pl/sql, what is bulk binding, and when/how would it help performance?
How to add a column ‘salary’ to a table employee_details?
How do you define a foreign key?
