how to change and modify a field

Question

Hi every body.

Whenever i want to modify a field of a table (delete or update), SQL server with showing a message doesn't allow me do it.

meanwhile i am aware of this matter that maybe the master table would have some details . but my case is something different , 

because for example when i decide to correct or modify the DataType of a field again it doesn't let me do that.

So is there any way in tools option or any other suggestion to solve it?

Answer 1

Hello,

Yes, there is an option in SSMS, see http://msdn.microsoft.com/en-us/library/ms188490(SQL.105).aspx => "Prevent saving changes that require table re-creation"

In menu Tools => Option , Tab Designer.

BTW, if you have a question, please start you thread as a "question", not as a "discusion".

---

Olaf Helper
* cogito ergo sum * errare humanum est * quote erat demonstrandum *
Wenn ich denke, ist das ein Fehler und das beweise ich täglich
Blog Xing

Answer 2

I intend to develope a registeration site for a university and for creating it's  database there is a table
 
known as persons ,that one of it's field is BirthDate.i also want that the design of my form to be somehow
 
which it's birthdate part to be made of  3 seprated and independed Day,Month & Year ComboBox.
 
my main problem is that i don't know whether the DataType of BirthDate field should be
 Date or char(10)or even Int?

Hi Olaf.would you please help me in my following quesiton.sorry for the font type!!

Thank you for your help and either your point about question and discusion.