问如何在一行中获得具有列名的表结构？

EN

SELECT 
    c.TABLE_NAME, 
    c.COLUMN_NAME, 
    c.DATA_TYPE, 
    CASE WHEN tc.CONSTRAINT_NAME IS NOT NULL THEN 1 ELSE 0 END AS IsPrimary
FROM INFORMATION_SCHEMA.COLUMNS c 
    LEFT JOIN (
        INFORMATION_SCHEMA.CONSTRAINT_COLUMN_USAGE ccu 
        JOIN INFORMATION_SCHEMA.TABLE_CONSTRAINTS tc 
        ON tc.CONSTRAINT_NAME = ccu.CONSTRAINT_NAME 
              AND tc.CONSTRAINT_SCHEMA = ccu.CONSTRAINT_SCHEMA 
              AND tc.CONSTRAINT_CATALOG = ccu.CONSTRAINT_CATALOG
          AND tc.CONSTRAINT_TYPE = 'PRIMARY KEY'
    )
    ON ccu.COLUMN_NAME = c.COLUMN_NAME 
      AND ccu.TABLE_NAME = c.TABLE_NAME 
      AND ccu.TABLE_SCHEMA = c.TABLE_SCHEMA 
      AND ccu.TABLE_CATALOG = c.TABLE_CATALOG
WHERE c.TABLE_NAME = 'Employee'

SELECT *
FROM INFORMATION_SCHEMA.COLUMNS
WHERE TABLE_NAME = N'TABLENAME';
GO