Stran z lastnostmi stolpcev (ADP)

Pomembno : Besedilo članka je prevedeno strojno. Glejte zavrnitev odgovornosti. Angleško različico tega članka najdete tukaj .

This property page contains a set of properties for a column within a table or for the set of output columns within a view or in-line function.

Table name

This property does not appear if you are working with a view or in-line function. Shows the name of the table containing the column whose properties you are viewing. The Table Name option is editable only within the Database Designer — not from within the Table Designer. If more than one table is selected in your diagram, only the name of the first table is visible.

Object name

This property does not appear if you are working with a table. Shows the name of the view or in-line function containing the output column whose properties you are viewing. The Object Name option is not editable.

Column Name

Shows the name of the selected column. To show properties for a different column, expand the Column Name list.

If you are working on a table, this shows the name of one of the table’s columns. If you are working on a view or in-line function, this shows the name of an output column.

Izraz

Velja le, če delate v pogledu ali funkciji v vrstici. Prikaže izraz zbirke podatkov za izhodnem stolpcu – stolpec, ki se prikaže v rezultatu funkcije pogleda ali v vrstici. Če stolpec, ki ustreza neposredno v izvorni stolpec, izraz prikažejo ime lastnika, ime tabele in ime stolpca. Na primer, če pogledu ali funkciji vključuje qty stolpec iz tabele sales , je izraz dbo.sales.qty.

Če stolpec nanaša na izpeljane stolpec, ki je določena v pogledu ali v vrstici funkcije, izraz kaže na določitev. Na primer stolpec, ki se imenuje profit bi izraza revenue-expenses.

Opis

(Microsoft SQL Server 2000 only.) Shows the text description of the selected column. The value is stored as a SQL Server extended property.

Data type

Prikazuje podatkovni tip izbranega stolpca.

If you are working with a view or in-line function, Data type applies only to output columns that correspond directly to columns in the underlying table, view, or function. In other words, if the output column is derived, the Data type property is blank. You cannot edit this property for a view or in-line function.

Dolžina

Applies only if you are working on a table. Shows the length of the selected column.

Nullable

Determines whether or not you can enter Null values in the column.

  • NIČELNA     Ničelne vrednosti so dovoljene.

  • NI NIČ     Ničelne vrednosti niso dovoljene.

Default Value

Applies only if you are working on a table. Shows the default for this column whenever a row with no value for this column is inserted into the table. The value of this field can be either the value of a SQL Server default constraint or the name of a global constraint to which the column is bound. The drop-down list contains all global defaults defined in the database. To bind the column to a global default, select from the drop-down list. Alternatively, to create a default constraint for the column, enter the default value directly as text.

Precision

Applies only if you are working on a table. Shows the maximum number of digits for values of this column.

Scale

Applies only if you are working on a table. Shows the maximum number of digits that can appear to the right of the decimal point for values of this column.

Identity

Applies only if you are working on a table. Shows whether the column is used by SQL Server as an identity column. Possible values are:

  • No     Stolpec ni uporabljen kot stolpec identitete.

  • Da     Stolpec, ki se uporablja kot stolpec identitete.

  • Da (ne za replikacijo)     Stolpec se uporablja kot stolpec identitete, razen med replikacijo posrednik je Vstavljanje podatkov v tabeli.

Identity Seed

Applies only if you are working on a table. Shows the seed value of an identity column. This option applies only to columns whose Identity option is set to Yes or Yes (Not For Replication).

Identity Increment

Applies only if you are working on a table. Shows the increment value of an identity column. This option applies only to columns whose Identity option is set to Yes or Yes (Not For Replication).

Is RowGuid

Applies only if you are working on a table. Shows whether the column is used by SQL Server as a ROWGUID column. You can set this value to Yes only for a column that is an identity column.

Formula

(SQL Server 7.0 or higher only.) Applies only if you are working on a table. Shows the formula for a computed column.

Collation

(SQL Server 2000 only.) Applies only if you are working on a table. Shows the collating sequence that SQL Server applies by default to the column whenever the column values are used to sort rows of a query result. To use the default collating sequence for the database, choose <database default>.

Oblika zapisa

(SQL Server 2000 only.) Shows the display format for the column. To change format, select a format from the list.

Decimal Places

Shows the number of decimal places to be used for displaying values of this column. If you choose Auto, the number of decimal places is determined by the value you choose in Format.

Input Mask

(SQL Server 2000 only.) To change the input mask, click in this text box, then click the button that appears alongside it.

Napis

(SQL Server 2000 only.) Shows the text label that appears by default in forms using this column.

Indexed

(SQL Server 2000 only.) Applies only if you are working on a table. Shows whether an index exists on the column. Possible values are:

  • No     Brez indeks obstaja v stolpcu.

  • Da (podvojeni vnosi dovoljeni v redu)     Ni enoličen indeks enim stolpcem obstaja v stolpcu.

  • Da (podvojeni vnosi niso dovoljeni)     Enolični indeks enim stolpcem obstaja v stolpcu.

Hyperlink

(SQL Server 2000 only.) Indicates whether the values in this column can be interpreted as hyperlinks.

IME Mode

(SQL Server 2000 only.) Determines the IME (Input Method Editor) status of the column when users enter values into that column. Your choices are:

  • Nadzora     Nadzora je privzeto.

  • On     Označuje urejevalnika vnosne METODE v in znakov, ki je značilna za kitajščini, japonščini ali korejščini lahko vnesete kot vrednosti v tem stolpcu.

  • Izklop Označuje urejevalnika vnosne METODE, je izklopljen. Ko uporabniki vnesejo vrednosti v stolpcu, na tipkovnici deluje enako kot način vnosa v angleščini.

  • Onemogočanje     Podobno kot »Izklopljeno« , le da »Onemogoči« prepreči, da bi uporabniki vklopite urejevalnika vnosne METODE.

  • Hiragana     Velja za japonščino IME le.

  • Katakana     Velja za japonščino IME le.

  • Katakano pol Velja za japonščino IME le.

  • Alfa polno     Velja za japonščino in korejskega ime-JA le.

  • Alfa Velja za japonščino in korejskega ime-JA le.

  • Celoten hangul     Velja za korejskega ime-JA le.

  • Pretvorba hangul     Velja za korejskega ime-JA le.

IME Sentence Mode

(SQL Server 2000 only.) Determines what additional IME conversion applies by default when users enter values into the column. Your choices are:

  • Predvidevanje faza     Označuje raven osnovne pretvorbe. To je privzeta.

  • Stavek množina     Podpira pretvorbe z uporabo dodatnih slovarji z imenom geografske in poštnih podatkov.

  • Pogovor     Podpira pretvorbe, ki prepozna pogovorni jezik.

  • Brez     Onemogoči pretvorbo znakov.

Furigana

(SQL Server 2000 only.) Indicates a column into which the Furigana equivalent of the text entered by the user is stored. When the user enters a value into this column, that value is stored, and in addition, the Furigana equivalent of the entered text is stored in the column named in this control.

Postal Address

(SQL Server 2000 only.) Specifies a control or field that displays either an address corresponding to an entered postal code or customer barcode data corresponding to an entered address.

Opomba : Strojni prevod – zavrnitev odgovornosti: Ta članek je bil preveden z računalniškim programom brez človeškega posredovanja. Microsoft skuša s strojno prevedenimi članki vsebino o Microsoftovih izdelkih, storitvah in tehnologijah približati osebam, ki ne razumejo angleščine. Ker je bil članek strojno preveden, so lahko v njem jezikovne, slovnične in pravopisne napake.

Razširite svoja znanja
Oglejte si izobraževanje
Prvi dobite nove funkcije
Pridružite se programu Office Insider

Vam je bila informacija v pomoč?

Zahvaljujemo se vam za povratne informacije.

Zahvaljujemo se vam za povratne informacije. Videti je, da bi vam prišla prav pomoč enega od naših Officeovih agentov za podporo.

×