Welcome to the CodeSmith Community!
Join
Sign in
Search Options
Search Everything
Search File Share
Home
Home
Store
Blogs
Forums
Gallery
Help
More ...
Home
»
File Share
»
Templates
»
Alter Table Create Identity Primary Key
Re: Alter Table Create Identity Primary Key
File Share
A description has not yet been added to this group.
Get this RSS feed
Home
Forums
Details
1
Reply
2
Subscribers
2656
days old
Options
Subscribe via RSS
Send to friend
Templates
Alter Table Create Identity Primary Key
rated by 0 users
This post has
1 Reply |
2
Followers
Posted by
slowram
on
Tue, Feb 14 2006 2:06 AM
rated by 0 users
Post Points: 35
Alter Table Create Identity Primary Key
AddIDIdentityPrimaryKeys.cst
The attached template works with v3.2 probably not 2.6. It generates SQL Alter Table scripts to create Identity Primary Keys on tables without a primary key. If it locates a table with an identity and not a key it has the option of creating the key on that field.
I needed this because I took over a database (sadly) with very few tables having Primary Keys defined and I got tired quickly of manually creating them/seeing which tables needed them.
Hope this helps someone,
Chad Biggerstaff
Posted by
Khaos
on
Tue, Mar 27 2007 2:11 PM
rated by 0 users
Post Points: 5
Re: Alter Table Create Identity Primary Key
The template is missing. Broken Link.
Joe Johnston
Page 1 of 1 (2 items)