Requesting a query for adding new columns in db

Hi i'm requesting a query to add more columns into a table, i need 3 more columns at shardservice since cleaned the db it only appears one column atm.

So if anyone got one feel free to post it.

Thanks in advance!

Go to your sql management studio right click at the table -> design and add the columns you need

EDIT:

and if you really want the query:

not sure if this is correct this is my source:
[Only registered and activated users can see links. Click Here To Register...]

Quote:

Originally Posted by kevin_owner Go to your sql management studio right click at the table -> design and add the columns you need EDIT: and if you really want the query: Code: ALTER TABLE shardservice SomeColumn BigInt not sure if this is correct this is my source: [Only registered and activated users can see links. Click Here To Register...]

Design doesn't work, because it will only add a new column with a new name, i just want to add columns under each name.

Imma try the query you linked, i tried one ALTER TABLE before but it didnt work. So lets see with this one :)

Nope didn't work at all it was the same as with the design...

To add a column in a table, use the following syntax

Quote:

ALTER TABLE table_name ADD column_name datatype