Necessary SQL query in MS SQL

less than 1 minute read

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

Comments