Posts

Showing posts from March, 2025

Get database object (dbo) type for given database and arrange asc

Image
 select distinct (type), type_desc from sys.objects order by type asc;

Check your RDBMS version information_ for MYSQL and Microsoft SQL

Image
  For MySQL : SELECT VERSION(); For Microsoft SQL Server : SELECT @ @VERSION ;

View information schema for all columns in Table. example - v_electrolyte_summary

Image
Select * from INFORMATION_SCHEMA.COLUMNS where TABLE_NAME = 'v_electrolyte_summary';  It gives 40 rows, indicates table 'v_electrolyte_summary' contains 40 columns.