sure lets say there are 3 tables (actually table will be decided at the runtime , nyways)

country , state , city in the source , they can be in...

but what if we dont knw the constriants and there name , we jus need to delete alll the constriants associated with a table

i was wondering if such an...

hi this query will result in all the views that depend on a table , something that can also be achieved by sp_depends <table name>

wat we are looking for is...

hi

thnx for all the help

SELECT COUNT(DISTINCT COALESCE(ProductID, '')) ProdCount, COUNT(DISTINCT COALESCE([OrderID], '')) OrderCount

FROM

 [Order Details]

will only give the total distincrt value. wat we need is the actual ProductID , its...

hi

thnx for the reply but this is exactly wat i have written.

basically wat we need is if there are other columns like orderId,CustomerId ....

it gives distinct of all these...

hi

The reason we need is that we are building a query builder kind of utility that wud query the view definition (which is already present in databases) and then wud query...

perfect Journeyman , this is wat we need , is it possible???

thats coz view is already created now we need to query the table based on where in view for that particular table

but wudnt this be specific for columns , wat we need is to query a view defintion and extract only those where clauses that are used for a particular table???

hi

to clarify the issue let the view be like

create view "Alphabetical list of products" AS

SELECT Products.*, Categories.CategoryName

FROM Categories INNER JOIN Products ON Categories.CategoryID = Products.CategoryID

WHERE Products.Discontinued =0  and Categories.CategoryID>12...

hi

to clarify the issue let the view be like

create view "Alphabetical list of products" AS

SELECT Products.*, Categories.CategoryName

FROM Categories INNER JOIN Products ON Categories.CategoryID = Products.CategoryID

WHERE Products.Discontinued =0  and Categories.CategoryID>12...

hi

to further clarify the issue

let the view be like create view "Alphabetical list of products" AS

SELECT Products.*, Categories.CategoryName

FROM Categories INNER JOIN Products ON Categories.CategoryID = Products.CategoryID

WHERE Products.Discontinued =0 and Products.productId>13...

hi

hope this makes it little clear

wat we need is to get all the where clause for a view which involve a particular table

so if there is a view that depends...