sql - Constrain a table to have only one row -


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