Friday, January 31, 2014

How to know table created date

SELECT create_date FROM sys.tables WHERE name='tblUsrShrProp'




SELECT
        [name]
       ,create_date
       ,modify_date
FROM
        sys.tables




SELECT su.name,so.name,so.crdate,* FROM sysobjects so JOIN sysusers su ON so.uid = su.uid WHERE xtype='U' ORDER BY so.name


SELECT OBJECT_NAME(OBJECT_ID) AS DatabaseName, last_user_update,* FROM sys.dm_db_index_usage_stats WHERE database_id = DB_ID( 'developer') AND OBJECT_ID=OBJECT_ID('tblusrshrprop')

No comments:

Post a Comment