SQL Script to find the tables created from a given date
Below is the SQL query which can be used to find out the tables which are created or modified on…
T-SQL script to find the highly populated tables in database
Sometimes we need to check which tables of our database is highly populated. Below is the T-SQL Script which we…
Adding , Deleting and Updating a Column in a table
Many times we need to alter the table definition by adding , deleting or updating a column in the table.…
How to rename a Table in Sql Server
To rename a column in a SQL Table following command can be reused: SP_RENAME ‘old table name’, ‘New table name’…
Renaming a column in Sql Server
We often need to change the name of a column of a table to a new name. We can do…
Different ways to create a table and insert data into the table
Introduction Tables can be defined as the structure which contains the data in the database. This article discuss about the…