I need help Altering table schema

Question

question

zillabaug asked Jul 15, '15

I need help Altering table schema

I need to add four new columns to a table (item) to accommodate additional data you see highlighted below in yellow.Can someone show me the how to do it? what is the Best practice when it come to altering table schema? Thanks [1]: /storage/temp/2615-schema-change.jpg

tsql schema sql server 2005

schema-change.jpg (132.9 KiB)

1

10 |1200

Attachments: Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Kev Riley ♦♦ commented · Jul 15, 2015 at 12:54 PM

https://msdn.microsoft.com/en-us/library/ms190273.aspx

1 ·

Answer 1 · 2015-07-15T13:18:31Z

Alvin Ramard answered Jul 15, '15

If you want to add columns to a table, you could start by taking a look at the ALTER TABLE command. [Add Columns to a Table (Database Engine)][1] [ALTER TABLE (Transact-SQL)][2] [1]: https://msdn.microsoft.com/en-us/library/ms190273.aspx [2]: https://msdn.microsoft.com/en-us/library/ms190273.aspx

10 |1200

Attachments: Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

question