SQL Documentor – Document Database | Export to PDF, HTML, Excel

System Views and Catalog views

SP_TABLES

EXEC sp_tables @table_type = “‘TABLE’”;

sysobjects

SELECT * FROM sysobjects
WHERE xtype = ‘U’;

Sys.tables

SELECT * FROM sys.tables;

Tags: sys.tables, sysobjects