i've to add 2 new fields in one of the table in databse, how can i do that?<BR><BR>thanks in advance
It probably depends on what program you're using but from mysql you'd issue a command like this to add a column:<BR><BR>ALTER TABLE table_name ADD COLUMN col_name col_definition
i'm using access database. thanks
Just open the table in design view and add the column. Microsoft has built in help which is quite comprehensive. I would suggest turning there for fundamental questions before posting.
Just open up the table in design mode and add the fields. As long as the properties of the new fields don't conflict with the existing data, it should let you do it.
actullu i want to add new fields using ASP page to the database which is on the server, without actually downloading database.<BR>so not through design view. <BR><BR>
set con = server.createobject("adodb.connection")<BR>con.ope n "your sysdsn"<BR>set rs = server.createobject("adodb.recordset")<BR>rs.lockt ype = 3<BR>rs.open "ALTER TABLE table_name ADD (col_name col_def)", con
so it would be something like<BR> <BR>rs.open "ALTER TABLE product ADD (status text)", con