Hi
I know sybase is not supported and not in the list. How to generate CSV file for sybase and import ERD into Lucid? Any help is appreciated.
I have below Query but not populating constrains data. i try to import the generate data into lucid chart i am getting error
Query
--------------
SELECT
'sybase' AS dbms,
db_name() AS TABLE_CATALOG,
user_name(o.uid) AS TABLE_SCHEMA,
o.name AS TABLE_NAME,
c.name AS COLUMN_NAME,
c.colid AS ORDINAL_POSITION,
t.name AS DATA_TYPE,
c.length AS CHARACTER_MAXIMUM_LENGTH,
-- Identify Primary Keys (Type 1 in syskeys)
CASE WHEN EXISTS (SELECT 1 FROM syskeys k WHERE k.id = o.id AND k.type = 1
AND c.name IN (col_name(k.id, key1), col_name(k.id, key2), col_name(k.id, key3)))
THEN 'PRIMARY KEY' ELSE NULL END AS CONSTRAINT_TYPE,
-- Identify Foreign Key References
user_name(ro.uid) AS REFERENCED_TABLE_SCHEMA,
ro.name AS REFERENCED_TABLE_NAME,
col_name(ro.id, k.key1) AS REFERENCED_COLUMN_NAME
FROM sysobjects o
JOIN syscolumns c ON o.id = c.id
JOIN systypes t ON c.usertype = t.usertype
LEFT JOIN syskeys k ON o.id = k.depid AND k.type = 2 -- Type 2 is Foreign Key
LEFT JOIN sysobjects ro ON k.id = ro.id -- Referenced (Parent) Object
WHERE o.type = 'U'
ORDER BY o.name, c.colid;
