Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

Content with tags Indexing, Primary Key (PK) Rss

   Items 1 to 4 of 4   
 

Stored procedure to script tables, has many options

I needed a fast way of creating identical copies of multiple tables. The criteria was to make identical copies of tables for a specific schema. Well there it started.  Read more...
By Gokhan Varol 2011/02/01 | Source: SQLServerCentral.com | Category: t-sql
Rating: (not yet rated) |  Discuss |   Briefcase | 2,237 reads

Primary Keys

By Paul Randal 2010/03/10 | Category: indexing
Rating: (not yet rated) |  Discuss |   Briefcase | 4,252 reads

how get primary key in any database

drop the primary key name is different for each database  Read more...
By Furanshizuku 2009/01/29 | Source: SQLServerCentral.com | Category: primary key (pk)
Rating: |  Discuss |   Briefcase | 1,263 reads

Getting unique or primary key columns for a given table

Following script will list out all the columns which have unique/primary key constraints for a given table.  Read more...
By Kiran Kumar 2009/01/02 | Source: SQLServerCentral.com | Category: primary key (pk)
Rating: |  Discuss |   Briefcase | 1,210 reads
   Items 1 to 4 of 4   
 
Tags
check constraint (1)    
create (1)    
databases (1)    
execute (1)    
foreign keys (fk) (1)    
table (1)    
t-sql (1)    
unique (1)    
unique index (1)    
xml (1)