I would like to be able to import a couple views into my ERD import section or into my saved shapes section. Is there a good way to do this?
Thanks
Page 1 / 1
Hi Andrew
Thanks for your post. Unfortunately there is no way to do this with ERD import at this time. I recommend posting in our product feedback space as this is the best way for our product team to hear your feedback on this.
Not perfect but this may help. They'll show as tables
SELECT 'sqlserver' as dbms
db_name() as TABLE_CATALOG
schema_name(v.schema_id) as TABLE_SCHEMA
object_name(c.object_id) as TABLE_NAME
c.name as COLUMN_NAME
c.column_id as ORDINAL_POSITION
type_name(user_type_id) as data_type
case charindex('char'type_name(user_type_id))
when 0 then null
else c.max_length end as CHARACTER_MAXIMUM_LENGTH
NULL as CONSTRAINT_TYPE
NULL as TABLE_SCHEMA
NULL as TABLE_NAME
NULL as COLUMN_NAME
FROM sys.columns c
JOIN sys.views v on v.object_id = c.object_id
ORDER BY schema_name(v.schema_id)
object_name(c.object_id)
column_id
Reply
Create an account in the community
A Lucid account is required to interact with the community. You will be redirected to the Lucid app to create an account.
Log in to the community
A Lucid account is required to interact with the community. You will be redirected to the Lucid app to log in.
Login with SSO
Log in with Lucidor
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
