Attribute name availablity checking

DataDictionaryQueries.sql

/*Check Attribute name availablity*/
SELECT TABLE_NAME FROM   DataBaseName_Here.INFORMATION_SCHEMA.COLUMNS WHERE  COLUMN_NAME = ‘Name'

--To check all the tables available in the Database
SELECT TABLE_NAME, TABLE_TYPE FROM DataBaseName_Here.INFORMATION_SCHEMA.TABLES ORDER BY TABLE_NAME

--To Get the list of columns
SELECT COLUMN_NAME FROM DataBaseName_Here.INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'Table Name here'

/*Queries to get all the data*/
SELECT * FROM INFORMATION_SCHEMA.TABLES
SELECT * FROM INFORMATION_SCHEMA.COLUMNS
SELECT * FROM INFORMATION_SCHEMA.KEY_COLUMN_USAGE

/*You need to follow this tutorial to learn the usage of these 
queries
link of the tutorial: https://youtu.be/4uvZtmRWS44*/