Ask Your Question
0

How to see the constraints in a Base table? [closed]

asked 2016-01-15 09:48:53 +0100

PeterOL gravatar image

updated 2016-03-10 22:20:20 +0100

Alex Kemp gravatar image

Is there any way to see the constraints that have been applied to the fields in a table in a database I am developing? The tables were mostly built in design view, some have been modified in SQL, but I don't have a record of the SQL. Thanks for any suggestions. LibreOffice 4.2 Base / Windows 10 English

edit retag flag offensive reopen merge delete

Closed for the following reason the question is answered, right answer was accepted by Alex Kemp
close date 2016-03-10 22:20:53.164319

2 Answers

Sort by » oldest newest most voted
0

answered 2016-02-04 09:35:23 +0100

PeterOL gravatar image

It's taken me weeks to find out, but I've finally discovered the answer to my question. It is to run the queries SELECT * FROM "INFORMATION_SCHEMA"."SYSTEM_COLUMNS" WHERE "TABLE_NAME" = '

'; and
SELECT * FROM "INFORMATION_SCHEMA"."SYSTEM_CHECK_CONSTRAINTS";

edit flag offensive delete link more
0

answered 2016-01-15 19:33:11 +0100

JohnSUN gravatar image

See here - Relations

Or here - Index design

Or unzip your .odb and look database\script

edit flag offensive delete link more

Comments

Sorry, maybe my question wasn't clear enough. I can see the foreign key constraints and the indices from the Relations diagram. What I'm looking for is the other attributes assigned to a field (other than those you can see by editing the table), such as UNIQUE, NOT NULL, CHECK conditions. I can't see anything which displays these characteristics for a given field.

PeterOL gravatar imagePeterOL ( 2016-01-15 20:53:16 +0100 )edit

Question Tools

1 follower

Stats

Asked: 2016-01-15 09:48:53 +0100

Seen: 691 times

Last updated: Jan 15 '16