sqlsql-serversql-server-2000

Get list of tables but not include system tables (SQL Server 2K)?


I know I can get a list of tables from a given database with the following query:

select *
from information_schema.tables

How do I go about excluding system tables though?


Solution

  • select name from sysobjects where type='U'