Posts

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.