Create Table [dbo].[DOVIZKURLARI](
[IDAuto] [int] Identity(1,1) Not Null,
[Tarih] [Date] Null,
[CrossOrder] [Smallint] Null,
[Kod] [NVarchar](5) Null,
[CurrencyCode] [NVarchar](5) Null,
[UNIT] [Varchar](50) Null,
[Isim] [Varchar](100) Null,
[CurrencyName] [Varchar](100) Null,
[ForexBuying] [Float] Null,
[ForexSelling] [Float] Null,
[BanknoteBuying] [Float] Null,
[BanknoteSelling] [Float] Null,
Constraint [PK_DOVIZKURLARI] Primary Key Clustered
(
[IDAuto] Asc
)With (Pad_Index = Off, Statistics_Norecompute = Off, Ignore_Dup_Key = Off, Allow_Row_Locks = On, Allow_Page_Locks = On) On [PRIMARY]
) On [PRIMARY]
go
Create NonClustered Index [IX_DOVIZKURLARI] On [dbo].[DOVIZKURLARI]
(
[Kod] Asc
)With (Pad_Index = Off, Statistics_Norecompute = Off, Sort_In_Tempdb = Off, Drop_Existing = Off, Online = Off, Allow_Row_Locks = On, Allow_Page_Locks = On) On [PRIMARY]
Go