Table objects definition

SELECT TABLES.name,TABLES.type_desc,CONVERT(NVARCHAR,TABLES.create_date,105) AS create_date ,CONVERT(NVARCHAR,TABLES.modify_date,105) AS modify_date,PARTITIONS.rows
FROM sys.tables TABLES
inner join sys.partitions PARTITIONS
	on PARTITIONS.object_id =  TABLES.object_id;