Member Avatar for mike.cook2

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
  • 134 Views
  • 6 Hours Discussion Span
  • Latest Post Latest Post by mike.cook2
Member Avatar for mike.cook2

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 developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.