The sys.tables system catalog view in MS-SQL Server stores information about all tables in a database. Each row represents a table and includes columns with information.