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?
I know this is quite an old question, but someone's just edited it to resurrect it, and the "right" answer from my perspective isn't either of the two listed. The accepted answer includes some "system" tables (dtproperties
is mentioned in the comments. If the user had any replication going on, they'd have found a few more).
The other answer uses a 2005 table, but is so nearly correct. For 2000, you want to use OBJECTPROPERTY
instead:
select name from sysobjects where
OBJECTPROPERTY(id,N'IsTable')=1 and
OBJECTPROPERTY(id,N'IsMSShipped')=0
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With