Click here to monitor SSC
SQLServerCentral is supported by Redgate
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: | Category: t-sql
Rating: (not yet rated) |  Discuss |   Briefcase | 2,282 reads

Primary Keys

By Paul Randal 2010/03/10 | Category: indexing
Rating: (not yet rated) |  Discuss |   Briefcase | 4,280 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: | Category: primary key (pk)
Rating: |  Discuss |   Briefcase | 1,284 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: | Category: primary key (pk)
Rating: |  Discuss |   Briefcase | 1,239 reads
   Items 1 to 4 of 4   
check constraints (1)    
create (1)    
databases (1)    
execute (1)    
foreign keys (fk) (1)    
table (1)    
t-sql (1)    
unique (1)    
unique index (1)    
xml (1)