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