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
Can a foreign key have a different name?
Why do we need cursor in pl sql?
What is db journal file?
What are character functions in sql?
What is sql and how does it work?
what is denormalization. : Sql dba
explain the options of myisamchk to improve the performance of a table. : Sql dba
Which is faster count (*) or count 1?
What are properties of the transaction?
Explain the difference between triggers and constraints?
What is trigger in pl sql with examples?
Is sql similar to python?
What is row_number () in sql?
can a stored procedure call itself or recursive stored procedure? : Sql dba
what are properties of a transaction? : Sql dba