Tag: ALTER TABLE

A primary key is a column or a group of columns that uniquely identifies each record in a table. You can create a primary key...

Sometimes you may need to change data type of a column in a table in MS SQL Server. To do this, you need to use...

Sometimes you need to set a restriction in a columns of a table which will not allow NULL values in MS SQL Server. To do...

Sometime you may need to delete one or more unused or obsolete columns from your existing table. To do this, you need use the ALTER TABLE...

If you have a column in a SQL Server table that does not allow NULL values and you want to insert row(s) with NULL values,...