View All Table/Stored Procedure/Function/View in a single DataBase

View All Table in a single DataBase-:

If you want to check, how many table you have create in a single DataBase

select * from INFORMATION_SCHEMA.TABLES

 for this you will have to select a single database

View All Stored Procedure in a single DataBase-:

To check, how many Stored Procedure ,you have create in a single DataBase.

select * from INFORMATION_SCHEMA.ROUTINES

View All Stored Procedure in a single DataBase before or after date-:

To check, how many Stored Procedure ,you have create in a single DataBase.

select * from INFORMATION_SCHEMA.ROUTINES  where created<'10/31/2012'

select * from INFORMATION_SCHEMA.ROUTINES  where created>'10/31/2012'

The date formate is (mm/dd/yyyy ) formate.

View All Stored Procedure in a single DataBase before or after changed/altered Date-:

To check, how many Stored Procedure ,you have changed or altered by a single Date in a single DataBase.

select * from INFORMATION_SCHEMA.ROUTINES  where LAST_ALTERED>'10/31/2012'

select * from INFORMATION_SCHEMA.ROUTINES  where LAST_ALTERED<'10/31/2012'

The date formate is (mm/dd/yyyy ) formate.

Display All VIEW in a single DataBase -:

To check, how many VIEWS ,you have created  in a single DataBase


select * from INFORMATION_SCHEMA.VIEWS

Display All VIEW in a single DataBase before or after creation date-:

To check, how many VIEWS ,you have create in a single DataBase.

select * from INFORMATION_SCHEMA.VIEWS  where created<'10/31/2012'

select * from INFORMATION_SCHEMA.VIEWS  where created>'10/31/2012'

The date formate is (mm/dd/yyyy ) formate.

Display All VIEW in a single DataBase before or after changed/altered Date-:

To check, how many VIEWS , you have changed or altered by a single Date in a single DataBase.

select * from INFORMATION_SCHEMA.VIEWS  where LAST_ALTERED>'10/31/2012'

select * from INFORMATION_SCHEMA.VIEWS  where LAST_ALTERED<'10/31/2012'

The date formate is (mm/dd/yyyy ) formate.


NOTE-: If you want to check how many function you have created in a single database, then run a Stored Procedure Query to check funtion details