Never mind... I found ....

http://stackoverflow.com/questions/14741054/delete-all-indexes-of-specific-database

No replies needed.. The above has the syntax.. COOL 🙂

Can you tell me how to get to this setting ?

( I mean how to navigate there )

OK, agreed!

Thanks for the HeadsUp!

Good work....

Luis, Yes

Reason: EXISTS is just a another subquery that runs for each row that was fetched. Subqueries take time.

The LEFT JOIN will figure out the data set just once (...

Beleive me, the LEFT OUTER JOIN is faster.

I deal with large tables and the "EXITS" make the query run for hours..

Great stuff

Thanks

Thanks

Ahh.. but you still have to manually go and replace every single quote with a double single quote.

I was thinking whether there was a way to get around that easily......

Ahhh good point!

>>>>

Are you trying to set the Connection property of the Execute SQL Task or the ConnectionString property of the Connection Manager?

What I believe you want to do...

Great! Works Well !

Thanks

Thank you dear!

Works like a charm!

Good job!

Cool! Thanks, worked well

Sorry I figured out

SELECT

TABLE_NAME,

COLUMN_NAME,

DATA_TYPE,

CHARACTER_MAXIMUM_LENGTH,

IS_NULLABLE,

NUMERIC_PRECISION,

NUMERIC_SCALE, *

FROM

INFORMATION_SCHEMA.COLUMNS A

inner join SYS.tables B

on ( A.TABLE_NAME = B.name )

Thnaks This works...

Hoewever can we limit it to showing only tables please. I see that It also lists the views.

SELECT

TABLE_SCHEMA, TABLE_NAME,

COLUMN_NAME,

DATA_TYPE,

CHARACTER_MAXIMUM_LENGTH,

IS_NULLABLE,

NUMERIC_PRECISION,

NUMERIC_SCALE

FROM

INFORMATION_SCHEMA.COLUMNS

This is not a duplicate post.

This is separate from the one where I asked for fks

Can you put together a SQL statement and using the variable please ?