How to add one column into existing SQL Table

Question

I have a SQL Server table and it is located on a remote server  I can connect to it with SQL Server Management Studio but opening it takes time instead  I am doing my jobs with SQL Query window without reaching it    Recently I ve made a change on the local copy of this table and want to update the remote one as well  All I ve done is adding one more column which is Nullable and I d like to learn how to add this one more column to the remote SQL Server with T-SQL without ruining the remote one data   Here is the additional info   Table Name  Products  Columns to be added  LastUpdate  Nullable and varchar 200   Thanks

User · Answer

Its work perfectly  ALTER TABLE  products  ADD  LastUpdate  varchar 200  NULL    But if you want more precise in table then you can try AFTER   ALTER TABLE  products  ADD  LastUpdate  varchar 200  NULL AFTER  column name     It will add LastUpdate column after specified column name  column name

User · Answer

What about something like   Alter Table Products Add LastUpdate varchar 200  null   Do you need something more complex than this

User · Answer

The syntax you need is  ALTER TABLE Products ADD LastUpdate  varchar 200  NULL   This is a metadata only operation

User · Answer

alter table table name add field name  size    alter table arnicsc add place number 10

[sql-server] How to add one column into existing SQL Table

Examples related to sql-server

Examples related to tsql

Examples related to sql-server-2008