0

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.

1
Contributor
1
Reply
2
Views
10 Years
Discussion Span
Last Post by mike.cook2
0

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

This question has already been answered. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.