Security & Virus | Hardware | Windows XP | Windows Vista | PC Gaming

SQL Query_Help needed

Comment:

Table Name : SYSTABLES tabid tabname Table Name : SYSREFERENCES constrid ptabid TableName: SYSCONSTRAINTS Constrid tabid I want to get the tabname corresponding to tabid present in SYSCONSTRAINT table and also I need the tabname corresponding to ptabid of SYSREFERENCES table. Note:tabname can be got only from systables only... Thanks in advance Joshna.. s.Guna

Reply:

I'm assuming, based on the table names, that your database is Informix. It's useful to say that when posting your question. Here is the select for the SYSCONSTRAINT table. That should be enough for you to do SYSREFERENCES: select tabname, constrname, idxname from sysconstraints,systables where systables.tabid = sysconstraints.tabid Here is a good online reference for the Informix system catalogue: http://publib.boulder.ibm.com/infoc...

0

Access 2000 query

ESQL/C Help needed

Post Locked

This post is quite old and has been locked from receiving new replies. Please create a new posting instead.

Summary: Personally I prefer ADO. I find it easier to use, and it's the successor to DAO. That said, if you want to run your SQL, you need to do something like this: Dim rs As DAO.Recordset Dim strSQL As Stri...

Summary: Hi, I'm designin sort of asset manager software and i'm already stuck with some SQL-querys... :) Tables don't have all the fields yet, because it's just a test version. I have these tables: 1)PC (Cent...

Summary: I need SQl query to find out the last modfied date of columns in table. there are no date/time related columns in the table. But I what to find when was the columns in the table are last modified. ...