how to select primary key

[mukeshrasm]

hi

I want to select primary key field from my table.

code which I tried SELECT FLIGHT_NO FROM FLIGHT. here FLIGHT_NO is primary key. but I am getting error : Invalid Column Name

but this code works fine in Access and MySql.

so what will be the right query ?

[code green]

I use all three database types you mention and am aware of some pitfalls.
Nothing is obviously wrong.
Do you have backticks or brackets around the field name or table name?
Can we see the exact query used in the three DBs.
Do you have such a field in the MsSql table?

[ck9663]

Are you trying to find the value of the column? Or are you trying to find out what is the PRIMARY KEY of the table?

If it's the former a simple

select ColumnName from YourTable.

if it's the latter,

sp_help YourTable

will show the PRIMARY KEY constraint...us ually at the end.

-- CK

[mukeshrasm]

Are you trying to find the value of the column? Or are you trying to find out what is the PRIMARY KEY of the table?

If it's the former a simple

select ColumnName from YourTable.

if it's the latter,

sp_help YourTable

will show the PRIMARY KEY constraint...us ually at the end.

-- CK

Hi

problem was resolved. actually i was putting bracket in the field name
which was unnecessary.

thanks !

[code green]

Ah! The square brackets used by Access.
Access and SQL server queries are not cross platform.
In fact Access seems to be more similar to MySql