Re: schema

On Thu, 9 Apr 1998 12:13:28 -0400, "bubba" <brittonb_at_webt.com> wrote:

>When looking at a table, the right hand side of the screen is so narrow.

Yes it is<g>.

>
>How can I widen the right hand side?

You can widen the entire right hand (or left) side by grabbing the vertical seperator bar and moving it either right or left. I suspect however, that you are having problems with the field widths themselves.

>I'm running into a problem where I can't see the actual constraint column
>because what looks like an activex control on the screen is to narrow.

I have this problem ALL THE TIME. I've always wondered what IDIOT at Oracle thought we would never have a constraint condition longer than a dozen or so characters.

>This is extremely annoying. I have to shrink all of the other column widths
>just to view the entire data in the column.

I can't even shrink my field widths. When I attempt to shrink other fields, my display gets even more messed up.

>Any body know how to make that whole right hand side better to view?

Want to know what I do? I use schema manager for PK and FK constraints, but for check constraints I just fire up SQL*Plus and issue this query:

	select constraint_name, search_condition
	from user_constraints
	where table_name = 'YOUR_TABLE_NAME_HERE'
	and constraint_type='C';

Maybe Oracle will fix this someday, but I've noticed that even the new 8.0 version works the same way.

regards,

Jonathan Received on Fri Apr 10 1998 - 20:46:15 CDT