pg sql

Sql code posted
created at 23 Nov 13:19, updated at 28 Nov 14:38

Edit | Back
1
2
3
4
5
6
7
8
9
10
DROP TABLE dbo.TemsItems
GO
CREATE TABLE dbo.TemsItems  ( 
    item_id   varchar(4) NOT NULL,
    item_key  varchar(32) NOT NULL,
    CONSTRAINT item_id_pk PRIMARY KEY(item_id)
)
GO
GRANT SELECT, INSERT, UPDATE, DELETE ON dbo.TemsItems TO admin
GO
254 Bytes in 3 ms with coderay