mirror of
https://github.com/acedanger/budget-database.git
synced 2025-12-05 14:40:14 -08:00
15 lines
305 B
Transact-SQL
15 lines
305 B
Transact-SQL
use Leo
|
|
go
|
|
|
|
if object_id('dbo.BUDGET_DETAIL', 'U') is not null
|
|
drop table dbo.BUDGET_DETAIL
|
|
go
|
|
|
|
create table dbo.BUDGET_DETAIL
|
|
(
|
|
TrxId int identity not null
|
|
, TrxDescription varchar(200) not null
|
|
, TrxDate date not null
|
|
, TrxAmount decimal(9,2)
|
|
, InsertDtTm datetime default CURRENT_TIMESTAMP
|
|
) |