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


Comments

No responses found. Be the first to comment...


  • Do not include your name, "with regards" etc in the comment. Write detailed comment, relevant to the topic.
  • No HTML formatting and links to other web sites are allowed.
  • This is a strictly moderated site. Absolutely no spam allowed.
  • Name:
    Email: