You can use a cursor on the sys_indexes table to pick up the primary keys and foreign keys, and drop them as needed.
"Alan Wolfe" <[EMAIL PROTECTED]> wrote: >hi everyone, > >when you create a key like this: > >alter table tranmaster add primary key (tranid) > >is there a way to name it instead of it just being given a number? > >or any way of choosing what number it uses? > >i want to automate some removing/adding constraints but right now each time the >command file is run i have to go through and find what # each constraint is that i >want to remove and change the numbers in the file. > >Looking in the docs i dont see a way but figured id ask just in case. > >Thank you! >Alan > -- Albert Berry Full Time Consultant to PSD Solutions 350 West Hubbard, Suite 210 Chicago, IL 60610 312-828-9253 Ext. 32 __________________________________________________________________ Introducing the New Netscape Internet Service. Only $9.95 a month -- Sign up today at http://isp.netscape.com/register Netscape. Just the Net You Need. New! Netscape Toolbar for Internet Explorer Search from anywhere on the Web and block those annoying pop-ups. Download now at http://channels.netscape.com/ns/search/install.jsp
