Re: Unique

From: Hari (hari_prasad_k_at_hotmail.com)
Date: 05/26/04 

Date: Wed, 26 May 2004 14:23:52 +0530

Hi,

Execute the below TSQL in query analyzer:-

select table_name,constraint_name,constraint_type,table_catalog as
database_name from information_schema.table_constraints where
constraint_type='UNIQUE'

Thanks
Hari
MCDBA

"Manisha" <anonymous@discussions.microsoft.com> wrote in message
news:E65836E5-51FB-4342-951A-934C1ABAE87E@microsoft.com...
> Which stored proc can be used to list all the unique constraints in all
the tables in a database?
> Thanks in advance!

Relevant Pages

  • Re: Dynamic use of Access query
    ... > But this code needs to add parameters from the query: ... > Set adoCmd = New ADODB.Command ... EXECUTE (this is what the ADO Command object is using under the hood ... If you are saying your stored proc doesn't have any parameters, ...
    (microsoft.public.excel.programming)
  • Re: stored proc RETURN_VALUE.... there it is, I want to use it !!!
    ... > Then you can read the value of @total after closing the query. ... > 2 Set up your input param values. ... the result of this sql code returns an integer that is ... >> take the guts of the stored proc with hard coded guestid and meeting ...
    (borland.public.delphi.database.ado)
  • Re: Stored procedure never finishes
    ... Perhaps when you run the query without the date range, ... You do this by issuing "exec sp_lock [spid]" with spid being ... SQL Server MVP ... > I have a stored proc that won't finish. ...
    (microsoft.public.sqlserver.server)
  • Re: Weird performance issue ....
    ... If I understand - the problem is with a query returned from a stored proc ... "a query making a user function call" you mean something different again). ... as PL/SQL is assumed to be a "batch" environment. ... Not taking about power since where the issue is, the server ...
    (comp.databases.oracle.server)
  • Re: Optimizer chooses different plans
    ... > When we execute a stored procedure it will do table scans, wether it is called from COM+ using ADO or executed in Query Analyzer. ... > If we cut and paste the code from the stored proc directly to Query Analyzer and execute it, ... > If I cut and paste this code into Query Analyzer AND remove the index hints it does Index Seeks on both tables using the indexes. ...
    (microsoft.public.sqlserver.server)