#beginning sql

There is a situations where you want to know the column names and it's data type and other column relevant  information of a particular table.

There are many situations where you want to get all tables name that contains particular column name using sql query.

Some time you Database Physical file Address and file size using sql script.

Sometimes we have situation in which we want delete all records of table and that table contains identity column as primary key and we want again insert some new records in this table , so in this case identity column does not start with 1 but it start with last number that we had before deleted records.

In some cases we need to get comma separated or any user defined separator values from table column. There are multiple solutions for that.