Practical Graph Structures in SQL Server and Azure SQL by Louis Davidson

Author:Louis Davidson
Language: eng
Format: epub
ISBN: 9781484294598
Publisher: Apress

The output of this query shows you the objects you worked with in the main example in the last two chapters.

Types of Graph Columns

Sometimes you need to see the physical column names for your graph db objects. The following two queries show the columns from a node and an edge:SELECT columns.name,

columns.column_id,

CASE

WHEN columns.name LIKE '$%' THEN

1

ELSE

0

END AS has_pseudocolumn,

columns.graph_type_desc

FROM sys.COLUMNS

WHERE OBJECT_ID('Network.Person') = COLUMNS.OBJECT_ID

AND columns.graph_type_desc IS NOT NULL;

Download

Copyright Disclaimer:
This site does not store any files on its server. We only index and link to content provided by other sites. Please contact the content providers to delete copyright contents if any and email us, we'll remove relevant links or contents immediately.