• lsrep17 Documentation
    • Tables [Sales].[CreditCard]
    expanded
    MS_Description
    Customer credit card information.
    expanded
    Properties
    PropertyValue
    CollationSQL_Latin1_General_CP1_CI_AS
    Row Count (~)19118
    Created13:14:19 14 marca 2012
    Last Modified13:14:54 14 marca 2012
    expanded
    Columns
    KeyNameData TypeMax Length (Bytes)Allow NullsIdentityDefaultDescription
    Cluster Primary Key PK_CreditCard_CreditCardID: CreditCardIDCreditCardIDint4
    False
    		1 - 1Primary key for CreditCard records.
    CardTypenvarchar(50)100
    False
    		Credit card name.
    Indexes AK_CreditCard_CardNumberCardNumbernvarchar(25)50
    False
    		Credit card number.
    ExpMonthtinyint1
    False
    		Credit card expiration month.
    ExpYearsmallint2
    False
    		Credit card expiration year.
    ModifiedDatedatetime8
    False
    		(getdate())Date and time the record was last updated.
    expanded
    Indexes
    KeyNameKey ColumnsUniqueDescription
    Cluster Primary Key PK_CreditCard_CreditCardID: CreditCardIDPK_CreditCard_CreditCardIDCreditCardID
    True
    		Primary key (clustered) constraint
    AK_CreditCard_CardNumberCardNumber
    True
    		Unique nonclustered index.
    expanded
    SQL Script
    CREATE TABLE [Sales].[CreditCard]
    (
    [CreditCardID] [int] NOT NULL IDENTITY(1, 1),
    [CardType] [nvarchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
    [CardNumber] [nvarchar] (25) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
    [ExpMonth] [tinyint] NOT NULL,
    [ExpYear] [smallint] NOT NULL,
    [ModifiedDate] [datetime] NOT NULL CONSTRAINT [DF_CreditCard_ModifiedDate] DEFAULT (getdate())
    ) ON [PRIMARY]
    GO
    ALTER TABLE [Sales].[CreditCard] ADD CONSTRAINT [PK_CreditCard_CreditCardID] PRIMARY KEY CLUSTERED  ([CreditCardID]) ON [PRIMARY]
    GO
    CREATE UNIQUE NONCLUSTERED INDEX [AK_CreditCard_CardNumber] ON [Sales].[CreditCard] ([CardNumber]) ON [PRIMARY]
    GO
    EXEC sp_addextendedproperty N'MS_Description', N'Customer credit card information.', 'SCHEMA', N'Sales', 'TABLE', N'CreditCard', NULL, NULL
    GO
    EXEC sp_addextendedproperty N'MS_Description', N'Credit card number.', 'SCHEMA', N'Sales', 'TABLE', N'CreditCard', 'COLUMN', N'CardNumber'
    GO
    EXEC sp_addextendedproperty N'MS_Description', N'Credit card name.', 'SCHEMA', N'Sales', 'TABLE', N'CreditCard', 'COLUMN', N'CardType'
    GO
    EXEC sp_addextendedproperty N'MS_Description', N'Primary key for CreditCard records.', 'SCHEMA', N'Sales', 'TABLE', N'CreditCard', 'COLUMN', N'CreditCardID'
    GO
    EXEC sp_addextendedproperty N'MS_Description', N'Credit card expiration month.', 'SCHEMA', N'Sales', 'TABLE', N'CreditCard', 'COLUMN', N'ExpMonth'
    GO
    EXEC sp_addextendedproperty N'MS_Description', N'Credit card expiration year.', 'SCHEMA', N'Sales', 'TABLE', N'CreditCard', 'COLUMN', N'ExpYear'
    GO
    EXEC sp_addextendedproperty N'MS_Description', N'Date and time the record was last updated.', 'SCHEMA', N'Sales', 'TABLE', N'CreditCard', 'COLUMN', N'ModifiedDate'
    GO
    EXEC sp_addextendedproperty N'MS_Description', N'Default constraint value of GETDATE()', 'SCHEMA', N'Sales', 'TABLE', N'CreditCard', 'CONSTRAINT', N'DF_CreditCard_ModifiedDate'
    GO
    EXEC sp_addextendedproperty N'MS_Description', N'Primary key (clustered) constraint', 'SCHEMA', N'Sales', 'TABLE', N'CreditCard', 'CONSTRAINT', N'PK_CreditCard_CreditCardID'
    GO
    EXEC sp_addextendedproperty N'MS_Description', N'Unique nonclustered index.', 'SCHEMA', N'Sales', 'TABLE', N'CreditCard', 'INDEX', N'AK_CreditCard_CardNumber'
    GO
    EXEC sp_addextendedproperty N'MS_Description', N'Clustered index created by a primary key constraint.', 'SCHEMA', N'Sales', 'TABLE', N'CreditCard', 'INDEX', N'PK_CreditCard_CreditCardID'
    GO
    expanded
    Uses
    expanded
    Used By