随笔分类 - 数据库

Firebird常用系统表Sql语句

摘要：--得到数据库的所有者名称SELECT distinct RDB$OWNER_NAME AS DATABASE_OWNERFROM RDB$RELATIONSWHERE (RDB$SYSTEM_FLAG = 1);--根据表名得到表的主键SELECT RC.RDB$CONSTRAINT_NAME AS CONSTRAINT_NAME, I.RDB$RELATION_NAME AS TABLE_NAME, S.RDB$FIELD_NAME AS COLUMN_NAMEFROM RDB$RELATION_CONSTRAINTS RC LEFT JOIN RDB$INDICES I ON (I.RD 阅读全文

posted @ 2011-05-31 21:03 fyen 阅读(3074) 评论(0) 推荐(0)

动态创建Access数据库文件

摘要：function CreateAccessFile(FileName: string; PassWord: string = ''): boolean;constSConnectionString = 'Provider=Microsoft.Jet.OLEDB.4.0;Data Source=%s;Jet OLEDB:Database Password=%s;';varvCatalog: OleV... 阅读全文

posted @ 2010-12-18 00:40 fyen 阅读(358) 评论(0) 推荐(0)