General form, DESCRIBE
TABLE statement:
DESCRIBE TABLE table-name-1<, ...
table-name-n>;
table-name
specifies the table
to be described as one of the following:
|
proc sql; create unique index daily on work.marchflights(flightnumber,date);
proc sql; describe table marchflights;
NOTE: SQL table WORK.MARCHFLIGHTS was created like:
create table WORK.MARCHFLIGHTS( bufsize=8192 )
(
Date num format=DATE9. informat=DATE9.,
DepartureTime num format=TIME5. informat=TIME5.,
FlightNumber char(3),
Origin char(3),
Destination char(3),
Distance num,
Mail num,
Freight num,
Boarded num,
Transferred num,
NonRevenue num,
Deplaned num,
PassengerCapacity num
);
create unique index daily on WORK.MARCHFLIGHTS(FlightNumber,Date); |