Run Code  | API  | Code Wall  | Users  | Misc  | Feedback  | Login  | Theme  | Privacy  | Patreon 

Get Tables

Language: Layout:
View schema
Execution time: 0,14 sec, rows selected: 17, rows affected: 0, absolute service time: 0,31 sec 
edit mode |  history
   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