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...