sqlgraph-databasesarcadedb
In Arcadedb how do I get a list of vertex types that are subtypes to a supertype?
I need to get a list of vertex types from the database that are subtypes to a supertype.
I.e. If I have a vertex structure that goes:
View -> Type1 -> Custom_Type_1
View -> Type1 -> Custom_Type_2
View -> Type2 -> Custom_Type_3
I want to be able to query....
"Get all type names that are subtypes to 'Type1'." So that it returns Custom_Type_1 and Custom_Type_2.
Note it is the type names I want, not the actual vertices of that type. I assume there must be a database metadata somewhere that could be queried but I can't find anything in the documentation to do this.
Am learning as ever.
Solution
You can query the schema and ask for the types with parent type equals to Type1:
select name from schema:types where 'Type1' IN parentTypes
- How can i insert/ select into a table and delete copied records from original table?
- Synapse/ ADF - How to Truncate table if dynamic config column is True in pre-copy script
- Fastest way to determine if record exists
- Select only distinct values from two tables on pgadmin without getting all combinations
- Unrecognized column name that I define
- How to merge 2 or more rows and SUM a column in an UPDATE without a primary key?
- SEDE Data Query to find posts that have hidden comments added by me
- What is the most efficient way to count rows in a table in SQLite?
- Renaming foreign-key columns in MySQL
- Fetch dates within the next 5 days from today, from a column of dates
- Preg split multi SQL by semicolon in PHP
- Mysql Pivot View
- Is it good practice to have a column for each user and a row for each user in SQL table?
- How to filter Select option to ALL
- error column cannot be null, trying to upload file into sql
- Function vs. Stored Procedure in SQL Server
- Left side of LIKE expression must evaluate to a varchar (actual: varbinary). What's an alternative to converting from varbinary to varchar?
- How to show the same field value from another entity attributes
- Big Query - Get continuous 7 characters from a long string in Big Query
- How to correctly join two tables that each have Start Date and Stop Date columns?
- PHP XAMPP Config
- SQL select distinct with condition
- To get the previous record which is less than the given date and time
- Create OBJECT with column values as Key in Snowflake
- How to load multiline csv feature into MySQL
- SQL copying data with new foreign keys
- An arithmetic expression with a DATETIME value is invalid while using PreparedStatement with Arithmetic calculation in sql later
- space is not allowed after parameter prefix ':' in SpEL support in Spring Data JPA @Query definitions
- postgres- plsql function to get rows counts for specific columns with null data
- SQLAlchemy - Get query results in same order as IN clause