Check your RDBMS version information_ for MYSQL and Microsoft SQL
For MySQL:
SELECT VERSION();
For Microsoft SQL Server:
SELECT @@VERSION;
View information schema for all columns in Table. example - v_electrolyte_summary
Select * from INFORMATION_SCHEMA.COLUMNS where TABLE_NAME = 'v_electrolyte_summary'; It gives 40 rows, indicates table 'v_electrolyte_summary' contains 40 columns.
Comments
Post a Comment