Table properties / Nested Select

• JJR333

  Default port

  Points: 1469

  More actions

  February 15, 2017 at 7:09 am

  #320370

  The query below does not return expected results with SOME databases.
  If I run the two queries separately I get the desired results.
  Any idea what is wrong?
  Cheers,
  Julian

  
SELECT  TABLE_SCHEMA, TABLE_NAME,
        '[' + TABLE_SCHEMA + '].' + '[' + TABLE_NAME + ']' SchemaAndTable,
        (    
        SELECT  name IDColumn
        FROM    syscolumns
        WHERE   COLUMNPROPERTY(id, name, 'IsIdentity') = 1
                AND TABLE_NAME = OBJECT_NAME (ID)
        )    
        as IdColumn
FROM    [WZH].INFORMATION_SCHEMA.TABLES
WHERE   TABLE_TYPE = 'BASE TABLE'


• JJR333

  Default port

  Points: 1469

  More actions

  February 15, 2017 at 7:14 am

  #1928617

  Sorry, found the issue.

  
use WZH;
GO