How To ENABLE a PRIMARY KEY in MS SQL Server
Sometimes you need to enable your disabled primary key in MS SQL Server. You can enable a primary key using the ALTER INDEX statement in...
How To DISABLE a PRIMARY KEY in MS SQL Server
Sometimes you may need to disable your primary key in MS SQL Server. You can delete your primary key directly but I recommend if you...
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....