How to DROP a PRIMARY KEY in MS SQL Server
Sometimes you may need to drop or delete primary key of a table in MS SQL Server. You can drop a primary key in SQL...
How to Create a PRIMARY KEY in SQL Server
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...
What is the Equivalent of DESCRIBE table in MS SQL Server
Working with a table sometimes we need to know the structure of the table i.e variable_name, variable_type, variable_size, constraint etc. In Oracle we use DESCRIBE...
Creating DESC Procedure To Describe Table in MS SQL Server
In Oracle it is easy to see the structure of a table by executing DESCRIPTION or DESC command. In SQL there is no such command....
How to Rename Column Name in MS SQL Server
Sometimes we need to rename a column name of a table in our MS SQL Server database. It is very much easy to change or...
How to Change Data Type of a Column in MS SQL Server
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...