HackStuff...
Aici veti gasi o gama larga de metode de hack atat pe Windows cat si pe platforme Linux/Unix , programe , tutoriale etc. In acelasi timp veti avea si asistenta help . Precizam ca tot ce se gaseste pe acest site este doar in scop de dezvoltare iar voi va asumati intreaga raspundere pt actiunile savarsite.ENJoY --- by andreony ---
|
Lista Forumurilor Pe Tematici
|
HackStuff... | Reguli | Inregistrare | Login
POZE HACKSTUFF...
Nu sunteti logat.
|
Nou pe simpatie:
ingera_31
 | Femeie
25 ani
Constanta
cauta Barbat
30 - 59 ani |
|
andreony
[admin]
 Din: bucharest
Inregistrat: acum 20 ani
Postari: 1062
|
|
Tipuri de date :
FieldType nFieldWidth nPrecision Description
C n - Character field of width n
D - - Date
T - - DateTime
N n d Numeric field of width n with d decimal places
F n d Floating numeric field of width n with d decimal places
I - - Integer
B - d Double
Y - - Currency
L - - Logical
M - - Memo
G - - General
P - - Picture
nFieldWidth and nPrecision are ignored for D, T, I, Y, L, M, G, and P types. nPrecision defaults to zero (no decimal places) if nPrecision isn’t included for the N, F, or B types.
Limbajul de descriere a datelor (LDD) :
Creeare tabele
Sintaxa
CREATE TABLE | DBF TableName1 [NAME LongTableName] [FREE]
(FieldName1 FieldType [(nFieldWidth [, nPrecision])]
[NULL | NOT NULL]
[CHECK lExpression1 [ERROR cMessageText1]]
[DEFAULT eExpression1]
[PRIMARY KEY | UNIQUE]
[REFERENCES TableName2 [TAG TagName1]]
[NOCPTRANS]
[, FieldName2 ...]
[, PRIMARY KEY eExpression2 TAG TagName2
|, UNIQUE eExpression3 TAG TagName3]
[, FOREIGN KEY eExpression4 TAG TagName4 [NODUP]
REFERENCES TableName3 [TAG TagName5]]
[, CHECK lExpression2 [ERROR cMessageText2]])
| FROM ARRAY ArrayName
Exemple
create table emitenti(;
simb char(10),;
denumire char(32) not null,;
cf char(8) not null,;
data_l date,;
piata char(12) check upper(piata)='BVB' or upper(piata)='RASDAQ',;
cap_soc number(10) check cap_soc>200 error "capital social prea mic",;
primary key simb tag emit_pk)
create table cotatii(;
simb char(10),;
data_c date,;
vol number(10) check vol>=0 error "volumul trebuie sa fie pozitiv",;
pret number(16,4) check pret>=0 error "pretul trebuie sa fie pozitiv",;
primary key simb+dtoc(data_c) tag cot_pk,;
foreign key simb tag c_e_fk references emitenti)
Modificare structură tabele
Sintaxa
ALTER TABLE TableName1
ADD | ALTER [COLUMN] FieldName1
FieldType [(nFieldWidth [, nPrecision])]
[NULL | NOT NULL]
[CHECK lExpression1 [ERROR cMessageText1]]
[DEFAULT eExpression1]
[PRIMARY KEY | UNIQUE]
[REFERENCES TableName2 [TAG TagName1]]
[NOCPTRANS]
– Or –
ALTER TABLE TableName1
ALTER [COLUMN] FieldName2
[NULL | NOT NULL]
[SET DEFAULT eExpression2]
[SET CHECK lExpression2 [ERROR cMessageText2]]
[DROP DEFAULT]
[DROP CHECK]
– Or –
ALTER TABLE TableName1
[DROP [COLUMN] FieldName3]
[SET CHECK lExpression3 [ERROR cMessageText3]]
[DROP CHECK]
[ADD PRIMARY KEY eExpression3 TAG TagName2]
[DROP PRIMARY KEY]
[ADD UNIQUE eExpression4 [TAG TagName3]]
[DROP UNIQUE TAG TagName4]
[ADD FOREIGN KEY [eExpression5] TAG TagName4
REFERENCES TableName2 [TAG TagName5]]
[DROP FOREIGN KEY TAG TagName6 [SAVE]]
[RENAME COLUMN FieldName4 TO FieldName5]
[NOVALIDATE]
Exemple
Alter table emitenti drop primary key
Alter table emitenti add primary key simb tag emit_pk
Alter table emitenti drop column piata
Alter table emitenti add column piata char(12)
Alter table emitenti alter column denumire char(35) not null
Alter table emitenti alter column piata set check upper(piata)='BVB' or upper(piata)='RASDAQ'
_______________________________________
------ eVoLuTiOn ------
|
|
| pus acum 20 ani |
|