Sp_tables vs sys.tables
sp_tables vs sys.tables
sp_tables
It is a stored procedures. It returns all tables and views in the current database.
sys.tables
It is a view. It returns all tables in current database
sp_tables vs sys.tables
sp_tables
It is a stored procedures. It returns all tables and views in the current database.
sys.tables
It is a view. It returns all tables in current database