Mar 19, 2001 #1 rickyuen Programmer Mar 19, 2001 1 HK How can I get the primary key(s) - the column name and their order - of a table from a front-end application via issung sql statement ?
How can I get the primary key(s) - the column name and their order - of a table from a front-end application via issung sql statement ?
Mar 20, 2001 #2 foxdev Programmer Feb 11, 2000 1,995 US Try executing the system stored procedure SP_HELPCONSTRAINT. Robert Bradley http://www.foxdev.com/Coming Soon: http://www.lowcostprints.comhttp://www.agrainofhope.org Upvote 0 Downvote
Try executing the system stored procedure SP_HELPCONSTRAINT. Robert Bradley http://www.foxdev.com/Coming Soon: http://www.lowcostprints.comhttp://www.agrainofhope.org