About Me

Barking, Essex, United Kingdom
MCITP DBA ,MCITP BI & Oracle OCP 11G

Thursday, April 18, 2013

Difference between sp_tables,sys.tables and information_schema.tables


SP_tables

Provides the information about table types such as tables and views and it’s related schema
With respect to the database  as found as below.













Select * from sys.tables

It provides the information about the object id such as table and table creation date and modify date
Plus locking information such as table level lock and replication publisher tables as found as below.


Select * from information_schema.tables

It provides the information about the tables and it's schema as found as below.






No comments:

Post a Comment