Necessary SQL query in MS SQL

SQL stands for Structured Query Languages. In this article, I will show you some important query you need frequently.

• Search a table name in a database in MS SQL Server

  SELECT * FROM INFORMATION_SCHEMA.TABLES 
  WHERE TABLE_NAME LIKE '%tablename%'
  

If you want to see all column of a joining table

select Region.* from Branch
inner join Region
on Branch.RegionId = Region.Id