Adding Columns to a Table with a Query in MS SQL

186 Reads Ms Sql

In MS SQL Server, the following procedure should be followed to add a column to a table with a query.

ALTER TABLE {Table Name} ADD {Column Name} {Data Type} {NULL or NOT NULL}

Example uses are given below..

ALTER TABLE Tbl_Customers ADD Address NVARCHAR(500) NULL ALTER TABLE Tbl_Products ADD ProdCode int NOT NULL
Ms Sql

You May Interest

Which TCP/IP Port Does the SQL Server Run On ?

When Will You Use SQLDiag Tool ?

What is a Covered Index in SQL Server ?

Getting Character Count in MS SQL

What is a Filestream in SQL Server ?