How to modify already created table?

CoolInterview.com - World's Largest Collection of Interview Questions

Sponsored Links

Interview Questions

Our Services

Get 9,000 Interview Questions & Answers in an eBook.

9500+ Pages
9000 Question & Answers
All Tech. Categories

14 MB Content

Get it now !!

INTERVIEW QUESTIONS DATABASE DETAILS

Question :
How to modify already created table?

Posted by: r.ravi on 5/19/2008

Contact r.ravi

Category Database Interview Questions

Rating (0.9) By 197 users

Added on 5/19/2008

Views 1755

Rate it!

Answers:

By using "alter" command we can modify already created table like
1)To add a new column
2)To drop a column
3)To rename a column
4)To change the data type

Posted by: praneeth

Contact praneeth

If you have the better answer, then send it to us. We will display your answer after the approval.
Rules to Post Answers in CoolInterview.com:-
There should not be any Spelling Mistakes.

There should not be any Gramatical Errors.

Answers must not contain any bad words.

Answers should not be the repeat of same answer, already approved.

Answer should be complete in itself.

Name :*

Email Id :*

Answer :*

Verification Code Not readable? Load New Code

  Enter the above shown code:*

Inform me about updated answers to this question



Related Questions View Answer

What is the meaning for data base without using technical terms? View Answer

What is Normalization? Explain all the normal forms? View Answer

How the database testing differs in Linux based system in comaprison with the windows based system?
What are the main differences and how to test it?
Please explain... View Answer

What does OFA stands for?
View Answer

I am new to field and trying to create trigger
have created a simle trigger :

create trigger trig before insert on practice1
for each row begin
insert into practice1 values ('d','d''ee','5')
end

for the excecution of the same displays me the error :
Incorrect syntax near 'before'.

Please let me know what is the error
is the syntax is correct
the database i m using is enterprise manager with sql server 2000

View Answer

What is Trigger? View Answer

What is basic difference between SQL Server2000 and oracle? View Answer

What is difference between oracle8i,oracle9i and oracle 10g. View Answer

What is serialization?
What is the difference between sql and oracle? View Answer

What magic table
What happen when we run any command or stored procedure is it compile ? View Answer

Please Note: We keep on updating better answers to this site. In case you are looking for Jobs, Pls Click Here Vyoms.com - Best Freshers & Experienced Jobs Website.
View ALL Database Interview Questions