예제 #1
0
        public object GetPrimaryKey(Util.SqlHelper sqlHelper, string dataBaseName, string tableName)
        {
            object pk = sqlHelper.ExecuteScalar("select column_name from user_cons_columns where constraint_name=(select constraint_name from user_constraints where upper(table_name)=upper('" + tableName + "') and constraint_type='P')");

            return(pk == null ? null : pk.ToString().FirstLetterToUpper());
        }
예제 #2
0
 public object GetPrimaryKey(Util.SqlHelper sqlHelper, string dataBaseName, string tableName)
 {
     return
         (sqlHelper.ExecuteScalar(string.Format(
                                      "select pg_attribute.attname as name from pg_constraint  inner join pg_class on pg_constraint.conrelid = pg_class.oid inner join pg_attribute on pg_attribute.attrelid = pg_class.oid and  pg_attribute.attnum = pg_constraint.conkey[1] inner join pg_type on pg_type.oid = pg_attribute.atttypid where pg_class.relname = '{0}' and pg_constraint.contype='p'", tableName)));
 }
예제 #3
0
        public object GetPrimaryKey(Util.SqlHelper sqlHelper, string dataBaseName, string tableName)
        {
            object pk = sqlHelper.ExecuteScalar("select name from sysibm.syscolumns where upper(tbname) = upper('" + tableName + "')  and keyseq > 0  order by keyseq asc");

            return(pk == null ? null : pk.ToString().FirstLetterToUpper());
        }