Click here to monitor SSC
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in

Content with tag unique Rss

   Items 1 to 3 of 3   

Declarative SQL: Using UNIQUE Constraints

In SQL, you can express the logic of what you want to accomplish without spelling out the details of how the database should do it. Nowhere is this more powerful than in constraints. In this introduction to Declarative SQL, Joe Celko demonstrates how you can write portable code that performs well and executes some complex logic, merely by creating unique constraints.  Read more...
By Additional Articles 2015/12/15 | Source: SimpleTalk | Category: constraints
Rating: (not yet rated)  Rate this |   Briefcase | 5,929 reads

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

Create/ drop unique key

This script will show you how to create/ drop unique key.  Read more...
By Michaƫl Hardman 2009/09/24 | Source: | Category: create
Rating: |  Discuss |   Briefcase | 657 reads
   Items 1 to 3 of 3   
create (2)    
primary key (pk) (2)    
check constraints (1)    
constraints (1)    
drop (1)    
execute (1)    
foreign keys (fk) (1)    
indexing (1)    
table (1)    
t-sql (1)    
xml (1)