question

zillabaug avatar image
zillabaug asked

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
tsqlschemasql server 2005
schema-change.jpg (132.9 KiB)
1 comment
10 |1200 characters needed characters left characters exceeded

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

1 Answer

· Write an Answer
Alvin Ramard avatar image
Alvin Ramard answered
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 characters needed characters left characters exceeded

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

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

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