Useful ASE stored procedures to check various constraints - Hallo there Sarah Server reader, this time we will talk about Useful ASE stored procedures to check various constraints, We have prepared this article for you, hope you enjoy this Guide, Happy reading.

Title : Useful ASE stored procedures to check various constraints
link : Useful ASE stored procedures to check various constraints

Useful ASE stored procedures to check various constraints

You can use the below set of stored procedures to find the same

Basic Level sp_helpindex tablename
Details
sp_fkeys tablename Gives details of foreign keys on the table having primary keys
sp_pkeys tablename Give details of the primary keys
sp_helpcontraint tablename, detail Gives details of all contraints on the table
sp_helpkey tablename Gives details of the keys associated with the table

There is Useful ASE stored procedures to check various constraints

Thus article Useful ASE stored procedures to check various constraints this time, hope can give benefits to all of you. well, see you in other post.

You are reading Useful ASE stored procedures to check various constraints with link https://saraserver.blogspot.com/2016/12/useful-ase-stored-procedures-to-check.html