知道一个对象，怎样得到它的详细信息
知道一个对象(包括表,存储过程....)，怎样得到它的详细信息(列名，创建日期...)，有没有什么系统的存储过程可以得到

[解决办法]
Identity Seed Increment Not For Replication
-------------------------------------------------------- ---------------------------------------- ---------------------------------------- -------------------
No identity column defined. NULL NULL NULL


RowGuidCol
--------------------------------------------------------
No rowguidcol column defined.


Data_located_on_filegroup
--------------------------------------------------------
PRIMARY


index_name index_description index_keys
-------------------------------------------------------- ------------------------------------------------------------------------------------------------------ ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------

dddd clustered located on PRIMARY FoodID
ffff nonclustered located on PRIMARY FoodID


constraint_type constraint_name delete_action update_action status_enabled status_for_replication constraint_keys
-------------------------------------------------------------------------- -------------------------------------------------------- ------------- ------------- -------------- ---------------------- ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
DEFAULT on column ProducerID DF_a_ProducerID (n/a) (n/a) (n/a) (n/a) (100)


没有外键引用此表。
没有架构绑定的视图引用此表。