Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Collation check Expand / Collapse
Author
Message
Posted Wednesday, April 17, 2013 4:42 PM
Right there with Babe

Right there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with Babe

Group: General Forum Members
Last Login: Thursday, July 31, 2014 7:04 PM
Points: 724, Visits: 1,002
How do I amend this to only show me tables,

select DISTINCT TABLE_NAME from INFORMATION_SCHEMA.COLUMNS
WHERE COLLATION_NAME <> 'SQL_Latin1_General_CP850_BIN'
AND TABLE_NAME <> 'syn%' order by TABLE_NAME ASC
Post #1443542
Posted Wednesday, April 17, 2013 4:58 PM


SSC-Insane

SSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-Insane

Group: General Forum Members
Last Login: Yesterday @ 4:34 PM
Points: 20,676, Visits: 32,269
Join it to the INFORMATION_SCHEMA.TABLES view by TABLE_NAME and filter TABLE_TYPE = 'BASE TABLE'.

Or add the following in the WHERE CLAUSE

exists(select 1 from INFORMATION_SCHEMA.TABLES t WHERE t.TABLE_NAME = c.TABLE_NAME and a.TABLE_TYPE = 'BASE TABLE') -- This assumes that you alias INFORMATION_SCHEMA.COLUMNS with a c in the FROM clause.



Lynn Pettis

For better assistance in answering your questions, click here
For tips to get better help with Performance Problems, click here
For Running Totals and its variations, click here or when working with partitioned tables
For more about Tally Tables, click here
For more about Cross Tabs and Pivots, click here and here
Managing Transaction Logs

SQL Musings from the Desert Fountain Valley SQL (My Mirror Blog)
Post #1443546
Posted Thursday, April 18, 2013 2:07 PM
Right there with Babe

Right there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with Babe

Group: General Forum Members
Last Login: Thursday, July 31, 2014 7:04 PM
Points: 724, Visits: 1,002
Thanks didn't know about the tables one..cheers
Post #1444133
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse