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

Content with tag Check Constraint Rss

   Items 1 to 3 of 3   
 

Introduction to SQL Server Check Constraints

Check Constraints play a very important role in SQL Server as it allows data validation rules to be imposed at the SQL Server instance level itself instead of writing rules for each application.   Read more...
By Additional Articles 2013/08/08 | Source: SQL Server Performance | Category: check constraint
Rating:  Rate this |   Briefcase | 4,833 reads

Enable/Disable a table to be read only on the fly

Wouldn't be nice if we can set the "read only" property of any table to be on or off easily with one simple stored procedure call?  Read more...
By Steven Rao 2013/07/30 | Source: SQLServerCentral.com | Category: read only
Rating: |  Discuss |   Briefcase | 6,919 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: SQLServerCentral.com | Category: t-sql
Rating: (not yet rated) |  Discuss |   Briefcase | 2,248 reads
   Items 1 to 3 of 3   
 
Tags
table (2)    
create (1)    
execute (1)    
foreign keys (fk) (1)    
indexing (1)    
primary key (pk) (1)    
read only (1)    
trigger (1)    
t-sql (1)    
unique (1)    
xml (1)