Hi. Can anyone help me with this? If I have, for example, a MSSQL database named 'COUNTRIES' and an existing table in the database named 'COMPANIES', can anyone let me know how I can add an additional field name 'PEOPLE' with a string datatype (for example) to this existing table using MSSQL script? Can anyone give me an example of the script I would have to use? I already know how to create a table, but don't know how to modify it using script.

Just found the answer! For reference it is (for example)
alter table COMPANIES add PEOPLE varchar(10) , ANOTHERFIELD varchar(10)

Be a part of the DaniWeb community

We're a friendly, industry-focused community of 1.19 million developers, IT pros, digital marketers, and technology enthusiasts learning and sharing knowledge.