Sometimes it is necessary to get the Creation Date,
Modification Date and detailed information about Tables, Stored Procedures,
Primary Keys, Foreign Keys and default constraints of a table or in the whole
database in SQL Server.
The Details information contains columns as:-
name,object_id,principal_id,schema_id,parent_object_id,type,type_desc,create_date,modify_date,is_ms_shipped,is_published,is_schema_published
