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