FREE AI-Enhanced Online SQL Server Compiler

Untitled*

You must execute the code again to save those values in the database.

Create Table tbl_a (id Int, name_a Text, date_a Date);
Insert Into tbl_a
  VALUES(1, 'A''s 1st row', '2025-07-20'), 
        (2, 'A''s 2nd row', '2025-07-23'), 
        (3, 'A''s 3rd row', '2025-07-25');
 GO
Select * From tbl_a;
GO
Create Table tbl_b (id Int, tbl_a_id Int, name_b Text, date_b Date);
Insert Into tbl_b
  VALUES(1, 1,  'B''s 1st row for a_id is 1', '2025-07-20'), 
        (2, 1, 'B''s 2nd row for a_id is 1', '2025-07-21'),
        (3, 3, 'B''s 1st row for a_id is 3', '2025-07-21');
GO
Select * From tbl_b;
GO
CREATE OR ALTER VIEW v_1 AS 
Select a.id, a.name_a, a.date_a, b.name_b, b.date_b
From   tbl_a a
Left Join tbl_b b ON(b.tbl_a_id = a.id);
GO
Select * From v_1;
GO
SELECT
    o.type_desc AS referencing_description, 
    OBJECT_NAME(referencing_id) AS referencing_entity_name,
    o2.type_desc AS referenced_description,
    referenced_entity_name
FROM sys.sql_expression_dependencies AS sed
INNER JOIN sys.objects AS o ON sed.referencing_id = o.object_id
INNER JOIN sys.objects AS o2 ON sed.referenced_id = o2.object_id
WHERE referencing_id = OBJECT_ID(N'v_1');
GO

id	name_a	date_a
1	A's 1st row	2025-07-20
2	A's 2nd row	2025-07-23
3	A's 3rd row	2025-07-25

id	tbl_a_id	name_b	date_b
1	1	B's 1st row for a_id is 1	2025-07-20
2	1	B's 2nd row for a_id is 1	2025-07-21
3	3	B's 1st row for a_id is 3	2025-07-21

id	name_a	date_a	name_b	date_b
1	A's 1st row	2025-07-20	B's 1st row for a_id is 1	2025-07-20
1	A's 1st row	2025-07-20	B's 2nd row for a_id is 1	2025-07-21
2	A's 2nd row	2025-07-23	NULL	NULL
3	A's 3rd row	2025-07-25	B's 1st row for a_id is 3	2025-07-21

referencing_description	referencing_entity_name	referenced_description	referenced_entity_name
VIEW	v_1	USER_TABLE	tbl_a
VIEW	v_1	USER_TABLE	tbl_b

(3 rows affected)

(3 rows affected)

(3 rows affected)

(3 rows affected)

(4 rows affected)

(2 rows affected)