时间：2021-07-01 10:21:17 帮助过：8人阅读
2 |
select first 10 skip 10 templateid,code,name from template ; |
3 |
select * from shop rows 1 to 10; --firebird2.0支持这种写法 |
二、show
1 |
show tables; |
2 |
show table tablename; |
三、
D:\firebird2\bin>isql -u sysdba -p masterkey
connect "E:\company\xmwsoft\newxmwsoft\c2\db\cts2.fdb";
四、--更新字段注释
1 |
update RDB$RELATION_FIELDS |
2 |
set RDB$DESCRIPTION = ‘描述信息‘ |
3 |
where (RDB$RELATION_NAME = ‘SHOP‘) and |
4 |
(RDB$FIELD_NAME = ‘CREDIT_BUY‘) |
五、--显示字段注释
1 |
select RDB$FIELD_NAME,RDB$DESCRIPTION from RDB$RELATION_FIELDS |