WITH foreign_data
AS (
    SELECT DISTINCT f.parent_object_id
        ,fc.parent_column_id
        ,OBJECT_NAME(f.parent_object_id) TableName
        ,COL_NAME(fc.parent_object_id, fc.parent_column_id) ColName
        ,OBJECT_NAME(f.referenced_object_id) ReferencedTableName
    FROM sys.foreign_keys AS f
    INNER JOIN sys.foreign_key_columns AS fc ON f.OBJECT_ID = fc.constraint_object_id
    INNER JOIN sys.tables ta ON ta.OBJECT_ID = fc.referenced_object_id
    )
SELECT tbl.name 'Table Name'
    ,c.NAME 'Column Name'
    ,t.NAME 'Data type'
    ,c.max_length 'Max Length'
    ,c.precision 'Precision'
    ,c.scale 'Scale'
    ,c.is_nullable 'Is Nullable'
    ,c.is_identity 'Is Identity'
    ,ISNULL(i.is_unique, 0) 'Is Unique'
    ,ISNULL(i.is_primary_key, 0) 'Primary Key'
    ,CASE 
        WHEN fk.ColName IS NULL
            THEN 0
        ELSE 1
        END 'Foreign Key'
FROM sys.tables tbl
INNER JOIN sys.columns c ON c.object_id = tbl.object_id
INNER JOIN sys.types t ON c.user_type_id = t.user_type_id
LEFT OUTER JOIN sys.index_columns ic ON ic.object_id = c.object_id
    AND ic.column_id = c.column_id
LEFT OUTER JOIN sys.indexes i ON ic.object_id = i.object_id
    AND ic.index_id = i.index_id
LEFT OUTER JOIN foreign_data fk ON fk.parent_column_id = c.column_id
    AND fk.parent_object_id = c.object_id
WHERE c.object_id = OBJECT_ID('Siswa')

WITH foreign_data
AS (
    SELECT DISTINCT f.parent_object_id
        ,fc.parent_column_id
        ,OBJECT_NAME(f.parent_object_id) TableName
        ,COL_NAME(fc.parent_object_id, fc.parent_column_id) ColName
        ,OBJECT_NAME(f.referenced_object_id) ReferencedTableName
    FROM sys.foreign_keys AS f
    INNER JOIN sys.foreign_key_columns AS fc ON f.OBJECT_ID = fc.constraint_object_id
    INNER JOIN sys.tables ta ON ta.OBJECT_ID = fc.referenced_object_id
    )
SELECT tbl.name 'Table Name'
    ,c.NAME 'Column Name'
    ,t.NAME 'Data type'
    ,c.max_length 'Max Length'
    ,c.precision 'Precision'
    ,c.scale 'Scale'
    ,c.is_nullable 'Is Nullable'
    ,c.is_identity 'Is Identity'
    ,ISNULL(i.is_unique, 0) 'Is Unique'
    ,ISNULL(i.is_primary_key, 0) 'Primary Key'
    ,CASE 
        WHEN fk.ColName IS NULL
            THEN 0
        ELSE 1
        END 'Foreign Key'
FROM sys.tables tbl
INNER JOIN sys.columns c ON c.object_id = tbl.object_id
INNER JOIN sys.types t ON c.user_type_id = t.user_type_id
LEFT OUTER JOIN sys.index_columns ic ON ic.object_id = c.object_id
    AND ic.column_id = c.column_id
LEFT OUTER JOIN sys.indexes i ON ic.object_id = i.object_id
    AND ic.index_id = i.index_id
LEFT OUTER JOIN foreign_data fk ON fk.parent_column_id = c.column_id
    AND fk.parent_object_id = c.object_id
ORDER BY tbl.name