Get database object (dbo) type for given database and arrange asc Get link Facebook X Pinterest Email Other Apps March 20, 2025 select distinct (type), type_desc from sys.objects order by type asc; Read more
Check your RDBMS version information_ for MYSQL and Microsoft SQL Get link Facebook X Pinterest Email Other Apps March 20, 2025 For MySQL : SELECT VERSION(); For Microsoft SQL Server : SELECT @ @VERSION ; Read more
View information schema for all columns in Table. example - v_electrolyte_summary Get link Facebook X Pinterest Email Other Apps March 20, 2025 Select * from INFORMATION_SCHEMA.COLUMNS where TABLE_NAME = 'v_electrolyte_summary'; It gives 40 rows, indicates table 'v_electrolyte_summary' contains 40 columns. Read more