SELECT

tbl.name AS [Name],

tbl.object_id AS [ID],

tbl.create_date AS [CreateDate],

tbl.modify_date AS [DateLastModified],

ISNULL(stbl.name, N'') AS [Owner],

CAST(case when tbl.principal_id is null then  else  end AS bit) AS [IsSchemaOwned],

SCHEMA_NAME(tbl.schema_id) AS [Schema],

CAST(

 case

    when tbl.is_ms_shipped =  then

    when (

        select

            major_id

        from

            sys.extended_properties

        where

            major_id = tbl.object_id and

            minor_id =  and

            class =  and

            name = N'microsoft_database_tools_support')

        is not null then

    else

end

             AS bit) AS [IsSystemObject],

CAST(OBJECTPROPERTY(tbl.object_id, N'HasAfterTrigger') AS bit) AS [HasAfterTrigger],

CAST(OBJECTPROPERTY(tbl.object_id, N'HasInsertTrigger') AS bit) AS [HasInsertTrigger],

CAST(OBJECTPROPERTY(tbl.object_id, N'HasDeleteTrigger') AS bit) AS [HasDeleteTrigger],

CAST(OBJECTPROPERTY(tbl.object_id, N'HasInsteadOfTrigger') AS bit) AS [HasInsteadOfTrigger],

CAST(OBJECTPROPERTY(tbl.object_id, N'HasUpdateTrigger') AS bit) AS [HasUpdateTrigger],

CAST(OBJECTPROPERTY(tbl.object_id, N'IsIndexed') AS bit) AS [HasIndex],

CAST(OBJECTPROPERTY(tbl.object_id, N'IsIndexable') AS bit) AS [IsIndexable],

CAST(CASE idx.index_id WHEN  THEN  ELSE  END AS bit) AS [HasClusteredIndex],

tbl.uses_ansi_nulls AS [AnsiNullsStatus],

CAST(OBJECTPROPERTY(tbl.object_id,N'IsQuotedIdentOn') AS bit) AS [QuotedIdentifierStatus],

CAST( AS bit) AS [FakeSystemTable],

ISNULL(dstext.name,N'') AS [TextFileGroup],

ISNULL( ( select sum (spart.rows) from sys.partitions spart where spart.object_id = tbl.object_id and spart.index_id < ), ) AS [RowCount],

tbl.is_replicated AS [Replicated],

CASE WHEN 'FG'=dsidx.type THEN dsidx.name ELSE N'' END AS [FileGroup],

CASE WHEN 'PS'=dsidx.type THEN dsidx.name ELSE N'' END AS [PartitionScheme],

CAST(CASE WHEN 'PS'=dsidx.type THEN  ELSE  END AS bit) AS [IsPartitioned]

FROM

sys.tables AS tbl

LEFT OUTER JOIN sys.database_principals AS stbl ON stbl.principal_id = ISNULL(tbl.principal_id, (OBJECTPROPERTY(tbl.object_id, 'OwnerId')))

INNER JOIN sys.indexes AS idx ON

            idx.object_id = tbl.object_id and (idx.index_id < )

LEFT OUTER JOIN sys.data_spaces AS dstext  ON tbl.lob_data_space_id = dstext.data_space_id

LEFT OUTER JOIN sys.data_spaces AS dsidx ON dsidx.data_space_id = idx.data_space_id

WHERE

(

--tbl.name='tablename' and

SCHEMA_NAME(tbl.schema_id)='dbo')