Forum Discussion
Element115
Memorable Member
Memorable MemberQUESTION::SQL ENDPOINT::INFORMATION_SCHEMA::QUERY RETURN NOTHING
Why do the following 2 TSQL queries return an empty result set? Also nothing with a WHERE clause on a table name in the LH. SELECT *
FROM INFORMATION_SCHEMA.VIEW_COLUMN_USAGE SEL...
Hi Element115
How did you create the view? Can you please share the code here?
If you create the view using the tables present in lakehouse, then it would be shown in the sql query result.
Element115Memorable Member
Memorable MemberCREATE VIEW vTABLE_NAMES
AS
SELECT *
FROM INFORMATION_SCHEMA.TABLES
WHERE TABLE_SCHEMA = 'dbo'
;