Thanks Albert! ----- Original Message ----- From: "Albert Berry" <[EMAIL PROTECTED]> To: "RBASE-L Mailing List" <[EMAIL PROTECTED]> Sent: Wednesday, April 21, 2004 10:11 AM Subject: [RBASE-L] - RE: naming constraings
> 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 >
