Hi there,
New to Redash. Can’t seem to view the primary keys of an existing table. Can do describe [tablename] but that doesn’t show the key types. Can someone help?
Thanks!
Hi there,
New to Redash. Can’t seem to view the primary keys of an existing table. Can do describe [tablename] but that doesn’t show the key types. Can someone help?
Thanks!
I used: EXECUTE sp_helpindex [tableName] and it worked fine!
Pretty sure this only works for MSSQL database types. Unclear what the command is for other databases like mysql or postgres