You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
C:\MIX\firebird\fb25\bin>isql /:e25 -z
ISQL Version: WI-V2.5.6.26990 Firebird 2.5
Server version:
WI-V2.5.6.26990 Firebird 2.5
WI-V2.5.6.26990 Firebird 2.5/tcp (csprog)/P12
WI-V2.5.6.26990 Firebird 2.5/tcp (csprog)/P12
Database: /:e25
SQL> help show;
Frontend commands:
. . .
SHOW <object> [<name>] -- display system information
<object> = CHECK, COLLATION, . . ., VIEW
...
All commands may be abbreviated to letters in CAPitals
SQL> recreate table test(x int, y int, constraint test_chk check( x+y > 0 ) );
SQL> show table test;
X INTEGER Nullable
Y INTEGER Nullable
CONSTRAINT TEST_CHK:
check( x+y > 0 )
SQL> show check test_chk;
There is no table TEST_CHK in this database
SQL> show check;
Command error: show check
The text was updated successfully, but these errors were encountered:
Submitted by: @pavel-zotov
C:\MIX\firebird\fb25\bin>isql /:e25 -z
ISQL Version: WI-V2.5.6.26990 Firebird 2.5
Server version:
WI-V2.5.6.26990 Firebird 2.5
WI-V2.5.6.26990 Firebird 2.5/tcp (csprog)/P12
WI-V2.5.6.26990 Firebird 2.5/tcp (csprog)/P12
Database: /:e25
SQL> help show;
Frontend commands:
. . .
SHOW <object> [<name>] -- display system information
<object> = CHECK, COLLATION, . . ., VIEW
...
All commands may be abbreviated to letters in CAPitals
SQL> recreate table test(x int, y int, constraint test_chk check( x+y > 0 ) );
SQL> show table test;
X INTEGER Nullable
Y INTEGER Nullable
CONSTRAINT TEST_CHK:
check( x+y > 0 )
SQL> show check test_chk;
There is no table TEST_CHK in this database
SQL> show check;
Command error: show check
The text was updated successfully, but these errors were encountered: