Re: SQL to search for column name

> I beleive you could start by looking at a lot of OTC's answers...... >The ones that say "RTFM", perhaps? But of course.....Which other answers would I mean? :-p

On 21 Jan 2006 01:17:36 -0800, theusarools@hotmail.co.uk wrote: >> I beleive you could start by looking at a lot of OTC's answers...... > >>The ones that say "RTFM", perhaps? > > But of course.....Which other answers would I mean? :-p I don't think "update statistics" would help here . . .8-) JWC

John Carlson said: > > On 21 Jan 2006 01:17:36 -0800, theusarools@hotmail.co.uk wrote: > >>> I beleive you could start by looking at a lot of OTC's answers...... >> >>>The ones that say "RTFM", perhaps? >> >> But of course.....Which other answers would I mean? :-p > > I don't think "update statistics" would help here . . .8-) How about RENAME DATABASE? -- Bye now, Obnoxio "C'est pas parce qu'on n'a rien ' dire qu'il faut fermer sa gueule" - Coluche did i mention i like nulls? heck, i even go so far as to say that all columns in a table except the primary key could/should be nullable. this has certain advantages, for example, if you need to insert a child record and you don't have a parent row for it, just do an insert into the parent table with the primary key value (everything else null), and voila, relational integrity is preserved. but this is, admittedly, a bit controversial among modellers. --r937, dbforums.com