Requesting a query for adding new columns in db

[FoxRayz]

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!

[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:

ALTER TABLE shardservice
SomeColumn BigInt

not sure if this is correct this is my source:

[FoxRayz]

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:

ALTER TABLE shardservice
SomeColumn BigInt

not sure if this is correct this is my source:

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...

[hamada619]

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

ALTER TABLE table_name
ADD column_name datatype