Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
sunsanvin
Master Smack Fu Yak Hacker
1274 Posts |
 Posted - 2013-07-04 : 08:41:58
|
| Hi Team,I've two datbases, dev and test. both are of same data. I've a user for both the databases ABC. this user is DBowner on both the databases.there is one table xyz_address.it has 14 coulmns, onr of those is primary key column. with Identity property. I'm doing alt+f1 on the same table on both the databases. surprisingly, on dev database, the primary key column is not coming up. rest of columns are available. I tried select * from that table. other than that column, all the data is coming up. select <column_name> from xyz_address is giving error as invalid column, but is working on testDB. what is this strange issue? please provideme your inputs.CheersArnavEven you learn 1%, Learn it with 100% confidence. |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2013-07-04 : 08:49:41
|
firset check column exists in dev dbSELECT * FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME='xyz_address' AND COLUMN_NAME = 'your pk column name' ------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/https://www.facebook.com/VmBlogs |
 |
|
|
|
|
|
Database owner not able to see a column