Creating columns in a table ?

[Karuzo]

Hey Guys,

I wanted to know how i can add columns to an existing table, and specify their data-type. but only if the columns don't exist. and what bout NOT NULL ? How would i add that to the datatype ? Like : x INT NOT NULL, ?

Regards,

KRZO.

[JR10]

You can use the ALTER statement.

http://www.w3schools.com/sql/sql_alter.asp

[Karuzo]

You can use the ALTER statement.

http://www.w3schools.com/sql/sql_alter.asp

Ah, perfect that's what i searched for .

And what about the NOT NULL ? is this correct:

  
db_connect(connect,ALTER ....  x INT NOT NULL) 
  

?

[JR10]

If you mean the syntax then yes.

[Karuzo]

Yeah, i think i got now what i need. Thanks.