What is the most common way to restrict an SQL table, so that it does not get more than one row?
Discuss why such a table may exist, but it is not how the hindrance should be implemented.
I have only one unique key column so far, which is a specific value, such as ALWAYS_0 TINIANT TAL primary key default (0) contract check_value check (ALWAYS_0 = 0)
. I'm guessing that there is a cleaner way to do this.
"Text">
I solved the same problem on SQL Server 2008 by creating a table with the same column and inserting the primary key on that column:
Create a table MyOneRowTable ([ID] (1) do not break the initial tap pk_MyOneRowTable primary key, - the rest column goes here);
Comments
Post a Comment