Re: set a constraint CHECK (columnname > 0) to a exist column
This is a discussion on Re: set a constraint CHECK (columnname > 0) to a exist column within the SQL Server forums, part of the Microsoft SQL Server category; --> You can add it as a table constraint. Example: ALTER TABLE mytable ADD CONSTRAINT CK_mytable_mycolumn CHECK (mycolumn > 0) ...
| |||||||
| FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
02-28-2008, 06:14 PM
| ||||
| ||||
 Re: set a constraint CHECK (columnname > 0) to a exist column You can add it as a table constraint. Example: ALTER TABLE mytable ADD CONSTRAINT CK_mytable_mycolumn CHECK (mycolumn > 0) Hope this helps, Gert-Jan Stephan Bremme wrote: > > MS-SQL v.8.00 (SQL-Server 2000): > > How can I do set a constraint { CHECK (columnname > 0) } to a exist column > in database table. > Everyone help? > > Thanks, Stephan      |
Linear Mode
