Query to select all table names that do not have an uppercase name

Question

Can someone provide me with a query to select a list of all tables in db that don't have uppercase names?

Answer 1

@gbn's answer is correct for any upgraded version of SQL Server.

For 2000:

SELECT * FROM
sysobjects
WHERE
   UPPER(name) COLLATE Latin1_General_BIN <> name COLLATE Latin1_General_BIN
AND OBJECTPROPERTY(ID,N'IsTable')=1 and OBJECTPROPERTY(ID,N'IsMSShipped')=0

Answer 2

SELECT * FROM
sys.tables -- or local equivalent. This is for SQL Server
WHERE
   UPPER(name) COLLATE Latin1_General_BIN <> name COLLATE Latin1_General_BIN

Answer 3

select , , , :

SELECT  name
FROM    sys.tables
WHERE   (name <> UPPER(name))

Answer 4

SELECT name
FROM sys.tables
WHERE name <> UPPER(name) COLLATE Latin1_General_BIN

Answer 5

SELECT name
FROM sys.tables 
WHERE CAST(name as varbinary) <> CAST(UPPER(name) as varbinary)