SELECT * FROM SYSOBJECTS WHERE xtype = 'U'; MS SQL Server About the author Xuan Ngo is the founder of OpenWritings.net. He currently lives in Montreal, Canada. He loves to write about programming and open source subjects.