Chapter 23 – Systems Views
“In the end we’ll remember not the words of our enemies, but the silence of our friends.”
- Martin Luther King, Jr.
System Views
The basics of the Azure SQL Data Warehouse system views are listed above.
sys.all_columns
SELECT name
,max_length
,precision
,scale
FROM sys.all_columns
The sys.all_columns view shows columns for both user-defined and system objects.
sys.all_objects
SELECT Name
,Type_Desc
,Create_Date
,Modify_Date
FROM sys.all_objects
WHERE name = 'Emp_Intl'
The sys.all_objects views shows user-defined ...
With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.
Start Free Trial
No credit card required