Primary Key finding

[vaani15]

I am looking for the query that will give me the name of the attribute that is the primary key of the table.

[mwasif]

DESCRIBE will display the whole table structure and SHOW KEYS will display the keys. The syntax is

DESCRIBE table_name;

SHOW KEYS FROM table_name;

[vaani15]

But, i want a query that take table name and return the attribute name having primary key not the any other key..

DESCRIBE will display the whole table structure and SHOW KEYS will display the keys. The syntax is

DESCRIBE table_name;

SHOW KEYS FROM table_name;

[pbmods]

Heya, vaani.

When you DESCRIBE your table, the primary key will have a value of 'PRI' in the `Key` column.

[vaani15]

Heya, vaani.

When you DESCRIBE your table, the primary key will have a value of 'PRI' in the `Key` column.

Thanks dear,
But the query you gave is not exceptable in MySQL. Every time i am trying to execute the query, it is giving error....

Please HELP!!!

[r035198x]

Thanks dear,
But the query you gave is not exceptable in MySQL. Every time i am trying to execute the query, it is giving error....

Please HELP!!!

Which query did you try and what error did you get?

[vaani15]

Which query did you try and what error did you get?

Sorry dear, Actually i am working in SQLServer..
I am using

 sp_helpconstraint Account

query. It gives me the list of the constraints present in the Account table.

I want to find the name of the column that is having primary key...
Please Please HELP!!!

[r035198x]

Sorry dear, Actually i am working in SQLServer..
..

In that case this was in the wrong forum and so I've moved it to the SQL Server forum.