System Views and Catalog views
Monday, October 20th, 2008SP_TABLES EXEC sp_tables @table_type = "'TABLE'"; sysobjects SELECT * FROM sysobjects WHERE xtype = 'U'; Sys.tables SELECT * FROM sys.tables;
SP_TABLES EXEC sp_tables @table_type = "'TABLE'"; sysobjects SELECT * FROM sysobjects WHERE xtype = 'U'; Sys.tables SELECT * FROM sys.tables;