Welcome to dbFreaks.com!
FAQFAQ    SearchSearch      ProfileProfile    Private MessagesPrivate Messages   Log inLog in

How to print constraints.

  
   Database Help (Home) -> Sybase RSS
Next:  Using ON EXISTING UPDATE on ASE  
Author Message
Serguei.Goumeniouk

External


Since: Aug 22, 2008
Posts: 1



(Msg. 1) Posted: Fri Aug 22, 2008 1:19 pm
Post subject: How to print constraints.
Archived from groups: comp>databases>sybase (more info?)
Dear Experts,
Is it possible (and how is it) to print all constraints on a given
table?
Regards,
Serguei.

 >> Stay informed about: How to print constraints. 
Back to top
Login to vote
Manish Negandhi

External


Since: Jan 15, 2008
Posts: 25



(Msg. 2) Posted: Fri Aug 22, 2008 9:24 pm
Post subject: Re: How to print constraints. [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
On Aug 23, 1:19 am, Serguei.Goumeni....TakeThisOut@cibc.ca wrote:
>    Dear Experts,
> Is it possible (and how is it) to print all constraints on a given
> table?
>   Regards,
>    Serguei.

Do you mean you want to see list of the constraints on a table , if so
execute sp_helpconstraint tablename

-HTH
Manish Negandhi
[TeamSybase]

 >> Stay informed about: How to print constraints. 
Back to top
Login to vote
Display posts from previous:   
Related Topics:
Problem with ASE 12.5 Backup Server - Hello everyone !!! My problem: I have recently installed ASE 12.5 on winxp. When I try to make a dump or load with isql or DBArtisan i get this message: "Can't open a connection to site 'SYB_BACKUP'. See the error log file in the SQL Server boot..

Tuning stored procedures - Hi Everyone; We are working on tuning a compact framework mobile application which uses the Sybase iAnywhere 9.0 as the database. Performance of the stored procedures have been really bad. But we are at our wits end trying to find out the Stored..

PERL DBI Sybase::DBD error --- Dynaloader.pm - Sybase.so - All - I hesitated to post this as I saw many similar postings in my trawlings. However I have been unable to determine the problem in relation to the answers I've seen for the similar problems. Basically I had a working version of DBI and Sybase:DBD..

does rownumber exist ? - Hello everyone, In a response of a query, I would like to select rows from the first row to the 10th row. And then later, I would like to select rows from the 11st row to 20th row.....And so on. I know that in Oracle DB, there is something which can..

Semistructured data in Sybase - Does (any version of) Sybase support the semistructured data model? Can XML documents be stored efficiently on a Sybase database server? What functionality (eg. indexing) and constraints (eg. schema enforcement) does Sybase offer to semistructured data...
   Database Help (Home) -> Sybase All times are: Pacific Time (US & Canada)
Page 1 of 1

 
 You can post new topics in this forum
You can reply to topics in this forum
You can edit your posts in this forum
You can delete your posts in this forum
You can vote in polls in this forum



[ Contact us | Terms of Service/Privacy Policy ]