Get database object (dbo) type for given database and arrange asc
select distinct (type), type_desc
from sys.objects
order by type asc;
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