Using this query you can find out the free space available for each database. --create a Table variable to store database informatio...
Read More
Create Data Dictionary in SQL Database
This query will create a Data dictionary of a database which can be very helpful while doing the documentation of a project. select...
Read More
Different ways to create a foreign key in an existing table
Here are the 3 different ways to add a Foreign Key in an existing table:- By using ADD CONSTRAINT with update and delete cascade co...
Read More
Find a Keyword in all Stored Procedures or whole Database
Find all Stored Procedures that reference a Column, Table Name or any keywo rd. Using this Query You can search for a column/table nam...
Read More
Subscribe to:
Posts
(
Atom
)