Read Information_Schema of a SQL Table?

Ok solved this as with constraintlist as ( select kcu. Table_name, kcu. Column_name, tc.

Constraint_type from information_schema. Table_constraints as tc join information_schema. Key_column_usage as kcu on kcu.

Constraint_schema = tc. Constraint_schema and kcu. Constraint_name = tc.

Constraint_name and kcu. Table_schema = tc. Table_schema and kcu.

Table_name = tc. Table_name where tc. Constraint_type in ( 'primary key') ) select col.

Column_name, cl. Constraint_type from information_schema. Columns col left join constraintlist cl on col.

Column_name = cl. Column_name and col. Table_name = cl.

Table_name where col. Table_name = 'table_name.

I cant really gove you an answer,but what I can give you is a way to a solution, that is you have to find the anglde that you relate to or peaks your interest. A good paper is one that people get drawn into because it reaches them ln some way.As for me WW11 to me, I think of the holocaust and the effect it had on the survivors, their families and those who stood by and did nothing until it was too late.