Interested to Buy Any Domain ? << Click Here >> for more details...
I have some 3 particular fields ..i want to know which all
tables have those 3 fields. Is there any way to identify..
can we know by quering system tables..
- 5 Answers
- 11867 Views
- CTS, I also Faced
- E-Mail Answers
Answer Posted / dalwinder singh--intense tech
db2 "select name ,tbname ,typeschema,source_tabname from
sysibm.syscolumns where name='coloumn name'"
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
Is db2 relational database?
Explain package in db2 and its advantages?
by using cursors , we can access particular records from the table based on some condition, i want to delete those selected records, how can we write a query for this in the program?
What do you mean by commit and rollback?
How is the value function used?
What is the default page size of buffer pools?
List some fields from sqlca?
What are the benefits of using the db2 database?
List out the data types available.
Cursors can be declared in both working-storage & procedure division, agreed. But is there any difference? If could you please suggest what is the difference
can all users have the privilage to use the sql statement select * (dml)?
Differentiate between cs and rr isolation levels? Where do you specify them?
what is the sqlcode -501
Is it possible to create an Instance in DB2 using DB2 Control Center ?
What is schema in db2?
