I am listing all FK constraints for a given table using INFORMATION_SCHEMA set of views with the following query: SELECT X.UNIQUE_CONSTRAINT_NAME, "C".*, "X".* FROM "INFORMATION_SCHEMA"."KEY_COLUMN_USAGE" AS "C" INNER JOIN "INFORMATION_SCHEMA"."REFERENTIAL_CONSTRAINTS" AS "X" ON "C"."CONSTRAINT_NAME" = ...
in Sql Server 2005, I have a master table, and several other tables which are related to this master through several one to many relations. How can I find all tables and fields which are in relation with the primary key in the master table, on "many" side? I know I can extract this by querying views from INFORMATION_SCHEMA, but I don't ...
I have one database in mysql. But when i log into phpMyAdmin , it shows another database called information_schema. Is that database always present with one database? I mean to say is there a copy of information_schema for every database present in mysql or is there one database called inforemation_schema per mysql server? If i modif...
Hi, Initially I would like to ask you to forget about hashing passwords or w/e related to passwords, this question is not related to securing passwords, etc and I do know/understand how this should be done. What is the best approach to store the data in question, considering performance on read/write - to build one or more tables? Sin...
How can I present the information in the imsmanifest.xml file of a SCORM package? What i need is to create a tree view or any other type of pictorial representation of the information of the package . ...
In PostgreSQL, column data for the structure of a table is stored in pg_attribute, with a few fields in pg_class, and a couple in pg_attrdef . But I do not see the precision or scale for a NUMERIC field type stored in there anywhere. It can be found in the INFORMATION_SCHEMA tables, but I am trying to avoid them, as they do not use o...
Hi, I have a series of stored procedures that select data from a db. I have a role (cctc_reader) that has execute permissions granted on the procedures. One of the procedure calls another stored procedure called recControl_system_option which in turn queries Information_schema.columns. The problem is that in this proc the query selec...
Hey, I need a stored procedure which in parameter have name of table(varchar) and it return names of columns in this specific table. It is possible ? I think about some SELECT which retrieve this names from table but I am weak at SQL :/ I add that I use Firebird 1.5 :/ ...
Hi, Many databases has a information_schema database, since it is a standard. I want to know where can i find the documentation of it. Such as meaning of columns etc. Thanks. ...
I need to have a list of tables in MySQL, that don`t have a column 'created' or 'modified', so I can add them if non existant. How can I achieve this? Thanks in advance for any help / hint. ...
In SQL Server, how can I get the referenced table + column name from a foreign key? Note: Not the table/column where the key is in, but the key it refers to. Example: When the key [FA_MDT_ID] in table [T_ALV_Ref_FilterDisplay]. refers to [T_AP_Ref_Customer].[MDT_ID] such as when creating a constraint like this: ALTER TABLE [dbo].[T_...