What dows ambigious indexes mean in this context? Will/Can this cause any error in future?Īs workaround I used sybase central (which by the way opens always on first monitor, not on the one where it was closed - ugly behaviour), and found that a item indices showed what i searched for.īut I still want to know how a programmatically solution looks like. But there was still the same result of ambiguous sysindexes.
SQL Fiddle MS SQL Server 2017 View Sample Fiddle Clear Text to DDL Schema Panel Use this. + case when (status & 16777216)0 then ', ' ORACLE-BASE - DBA Scripts for Oracle 12c, 11g, 10g, 9i and 8i. + 'statistics' else case when (status & 32)0 then ', ' 'index_description' = convert(varchar(210),Ĭase when (status & 16)0 then 'clustered' else 'nonclustered' end click the Tables/Queries tab, and look in the SQL Server Compatible Syntax area. 'column_name' = index_col(object_name(id),indid,1), Right-click anywhere in the Relationships window and select Show Table. I found on internet the query: select 'Table name' = object_name(id), Therefore I search for a quick way to list all tables with unique primary keys.Īnweisung konnte nicht ausgeführt werden. ARCHITECTING MICROSOFT SQL SERVER ON VMWARE VSPHERE the Microsoft Windows Server Virtualization Validation Program12. In the db there are indices, which are unique, but shouldn't be unique. We are using a Sybase SQL Anywhere 12 db.
