Login

Rollonz.com is social bookmarking site.There is no need of registration.

2

Over 40 queries to find SQL Server tables with or without a certain property posted by user XMLBee 1059 days ago
Over 40 queries to find SQL Server tables with or without a certain property

       All comments are reviewed, so stay on subject or we may delete your comment       Note your email address is not published Required fields are marked with an asterisk (*)Immense Aaron Thank youOne more for the pot Tables holding GUIDs (hopefully not a Primary_Key)SELECT [table] = sname + N + t

There are many scripts I use over and over again, and since I continue to see slightly different questions with slightly different answers, but all along the same theme, I thought it would be useful to compile them in one place. (I'm going to leave out questions that can be answered quite simply by sys.tables alone, such as whether a table is involved in replication, is tracked by Change Data Capture, or was created with ANSI NULLS ON.) Can you do most or all of these things in other ways (li

Comments


To add a comment, please sign in