SQL Server : what is INFORMATION_SCHEMA Views

In SQL Server, sometimes we need to know the detailed description of database object then we have to use information schema view . 

INFORMATION_SCHEMA Views allow to retrieve metadata information of database object. 

INFORMATION_SCHEMA Views can be found in master database within system database. 


System Database/master/views/.. under view you will get list of INFORMATION_SCHEMA VIEWS. 

These views can be called from any sql server instance.

--Get Metadata Information about Table
select * from INFORMATION_SCHEMA.TABLES
where TABLE_NAME='Advertisement'

--Get Metadata Information about columns of Table
select * from INFORMATION_SCHEMA.COLUMNS
where TABLE_NAME='Advertisement'

 

"Tricks Always Work"