If i wanted to Change(i.e. modify a tables DESIGN add fields ect...) I know you can modify data.<BR><BR>Why would i want this?<BR>I have a large site access backend. Tons of data. But its hosted by someone else (isp) so i have to DL the DB (time consuming) then change the Design, then reupload it ... That’s down time. I know i could just do it at 4 in the morning but. Y if you don’t have to. So my question is can you change the DESIGN of a database in a browser?<BR>
like i said you can change the design form the front end with the alter table or drop table or create table statements and execute them.<BR><BR>What have you tried that you are asking if it can be done...are you getting an error
No error, i am new to ASP, and i have built a large site that is database driven. As the sites popularity grows i am sure i will add more functionality, thus the need to make changes to the design of the database. Do you know where i can learn more about this alter table command? I have the SAMS ASP in 24 hrs (not impressed with it at all) but it has no references to this command.