469,603 Members | 2,135 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,603 developers. It's quick & easy.

Auto Primary Keys in View

Hello Friends,

I've a table with no primary key. I want to create a View based on that table but I want a auto increamenting primary key in this View.

Does anybody know how to do this?

Plz help me..

Thanks in advance...
Mar 5 '08 #1
1 1386
ck9663
2,878 Expert 2GB
Hello Friends,

I've a table with no primary key. I want to create a View based on that table but I want a auto increamenting primary key in this View.

Does anybody know how to do this?

Plz help me..

Thanks in advance...
Two things you need.

1. Here's the syntax to create view.

2. Your query inside your view can include a dynamic row number. Here's how you do that.

-- CK
Mar 5 '08 #2

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

5 posts views Thread by Geoff Cayzer | last post: by
6 posts views Thread by Sebastien | last post: by
18 posts views Thread by Thomas A. Anderson | last post: by
7 posts views Thread by Dave | last post: by
8 posts views Thread by Paul Hunter | last post: by
reply views Thread by guiromero | last post: by
reply views Thread by devrayhaan | last post: by
reply views Thread by gheharukoh7 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.