Get Tables

  
TABLE_CATALOG
TABLE_SCHEMA
TABLE_NAME
ORDINAL_POSITION
COLUMN_NAME
DATA_TYPE
CHARACTER_MAXIMUM_LENGTH
IS_NULLABLE
NUMERIC_PRECISION
NUMERIC_SCALE

1
rextester
dbo
Flights
1
ID
int
NULL
NO
10
0

2
rextester
dbo
Flights
2
From
nvarchar
100
NO
NULL
NULL

3
rextester
dbo
Flights
3
To
nvarchar
100
NO
NULL
NULL

4
rextester
dbo
Flights
4
Departure_date
datetime
NULL
NO
NULL
NULL

5
rextester
dbo
Flights
5
Planes_ID
int
NULL
YES
10
0

6
rextester
dbo
Pilots
1
ID
int
NULL
NO
10
0

7
rextester
dbo
Pilots
2
First_name
nvarchar
100
NO
NULL
NULL

8
rextester
dbo
Pilots
3
Last_name
nvarchar
100
NO
NULL
NULL

9
rextester
dbo
Pilots
4
Title
nvarchar
100
NO
NULL
NULL

10
rextester
dbo
Pilots
5
Birth_date
date
NULL
NO
NULL
NULL

11
rextester
dbo
Pilots
6
Pilots_ID
int
NULL
YES
10
0

12
rextester
dbo
Pilots_on_flights
1
Flights_ID
int
NULL
NO
10
0

13
rextester
dbo
Pilots_on_flights
2
Pilots_ID
int
NULL
NO
10
0

14
rextester
dbo
Planes
1
ID
int
NULL
NO
10
0

15
rextester
dbo
Planes
2
Model
nvarchar
100
NO
NULL
NULL

16
rextester
dbo
Planes
3
Built_date
date
NULL
NO
NULL
NULL

17
rextester
dbo
Planes
4
Number_of_seats
int
NULL
NO
10
0