Crea, confirma y despliega tablas

  
sql server version

1
Microsoft SQL Server 2014 - 12.0.2000.8 (Intel X86) 
	Feb 20 2014 19:20:46 
	Copyright (c) Microsoft Corporation
	Express Edition on Windows NT 6.3 <X64> (Build 9600: ) (WOW64) (Hypervisor)



  
name
id
xtype
uid
info
status
base_schema_ver
replinfo
parent_obj
crdate
ftcatid
schema_ver
stats_schema_ver
type
userstat
sysstat
indexdel
refdate
version
deltrig
instrig
updtrig
seltrig
category
cache

1
sysrscols
3
S 
4
0
0
0
0
0
20.02.2014 20:48:35
0
0
0
S 
1
1
0
20.02.2014 20:48:35
0
0
0
0
0
2
0

2
sysrowsets
5
S 
4
0
0
0
0
0
13.04.2009 12:59:11
0
0
0
S 
1
1
0
13.04.2009 12:59:11
0
0
0
0
0
2
0

3
sysclones
6
S 
4
0
0
0
0
0
20.02.2014 20:48:35
0
0
0
S 
1
1
0
20.02.2014 20:48:35
0
0
0
0
0
2
0

4
sysallocunits
7
S 
4
0
0
0
0
0
13.04.2009 12:59:11
0
0
0
S 
1
1
0
13.04.2009 12:59:11
0
0
0
0
0
2
0

5
sysfiles1
8
S 
4
0
0
0
0
0
08.04.2003 09:13:38
0
0
0
S 
1
1
0
08.04.2003 09:13:38
0
0
0
0
0
2
0

6
sysseobjvalues
9
S 
4
0
0
0
0
0
20.02.2014 20:48:35
0
0
0
S 
1
1
0
20.02.2014 20:48:35
0
0
0
0
0
2
0

7
syspriorities
17
S 
4
0
0
0
0
0
20.02.2014 20:48:35
0
0
0
S 
1
1
0
20.02.2014 20:48:35
0
0
0
0
0
2
0

8
sysdbfrag
18
S 
4
0
0
0
0
0
20.02.2014 20:48:35
0
0
0
S 
1
1
0
20.02.2014 20:48:35
0
0
0
0
0
2
0

9
sysfgfrag
19
S 
4
0
0
0
0
0
20.02.2014 20:48:35
0
0
0
S 
1
1
0
20.02.2014 20:48:35
0
0
0
0
0
2
0

10
sysdbfiles
20
S 
4
0
0
0
0
0
20.02.2014 20:48:35
0
0
0
S 
1
1
0
20.02.2014 20:48:35
0
0
0
0
0
2
0

11
syspru
21
S 
4
0
0
0
0
0
20.02.2014 20:48:35
0
0
0
S 
1
1
0
20.02.2014 20:48:35
0
0
0
0
0
2
0

12
sysbrickfiles
22
S 
4
0
0
0
0
0
20.02.2014 20:48:35
0
0
0
S 
1
1
0
20.02.2014 20:48:35
0
0
0
0
0
2
0

13
sysphfg
23
S 
4
0
0
0
0
0
20.02.2014 20:48:35
0
0
0
S 
1
1
0
20.02.2014 20:48:35
0
0
0
0
0
2
0

14
sysprufiles
24
S 
4
0
0
0
0
0
20.02.2014 20:48:35
0
0
0
S 
1
1
0
20.02.2014 20:48:35
0
0
0
0
0
2
0

15
sysftinds
25
S 
4
0
0
0
0
0
13.04.2009 12:59:11
0
0
0
S 
1
1
0
13.04.2009 12:59:11
0
0
0
0
0
2
0

16
sysowners
27
S 
4
0
0
0
0
0
13.04.2009 12:59:11
0
0
0
S 
1
1
0
13.04.2009 12:59:11
0
0
0
0
0
2
0

17
sysdbreg
28
S 
4
0
0
0
0
0
20.02.2014 20:48:35
0
0
0
S 
1
1
0
20.02.2014 20:48:35
0
0
0
0
0
2
0

18
sysprivs
29
S 
4
0
0
0
0
0
13.04.2009 12:59:10
0
0
0
S 
1
1
0
13.04.2009 12:59:10
0
0
0
0
0
2
0

19
sysschobjs
34
S 
4
0
0
0
0
0
13.04.2009 12:59:11
0
0
0
S 
1
1
0
13.04.2009 12:59:11
0
0
0
0
0
2
0

20
syscsrowgroups
35
S 
4
0
0
0
0
0
20.02.2014 20:48:35
0
0
0
S 
1
1
0
20.02.2014 20:48:35
0
0
0
0
0
2
0

21
sysexttables
37
S 
4
0
0
0
0
0
20.02.2014 20:48:35
0
0
0
S 
1
1
0
20.02.2014 20:48:35
0
0
0
0
0
2
0

22
syscolpars
41
S 
4
0
0
0
0
0
13.04.2009 12:59:11
0
0
0
S 
1
1
0
13.04.2009 12:59:11
0
0
0
0
0
2
0

23
sysxlgns
42
S 
4
0
0
0
0
0
20.02.2014 20:48:35
0
0
0
S 
1
1
0
20.02.2014 20:48:35
0
0
0
0
0
2
0

24
sysxsrvs
43
S 
4
0
0
0
0
0
20.02.2014 20:48:35
0
0
0
S 
1
1
0
20.02.2014 20:48:35
0
0
0
0
0
2
0

25
sysnsobjs
44
S 
4
0
0
0
0
0
13.04.2009 12:59:11
0
0
0
S 
1
1
0
13.04.2009 12:59:11
0
0
0
0
0
2
0

26
sysusermsgs
45
S 
4
0
0
0
0
0
20.02.2014 20:48:35
0
0
0
S 
1
1
0
20.02.2014 20:48:35
0
0
0
0
0
2
0

27
syscerts
46
S 
4
0
0
0
0
0
13.04.2009 12:59:13
0
0
0
S 
1
1
0
13.04.2009 12:59:13
0
0
0
0
0
2
0

28
sysrmtlgns
47
S 
4
0
0
0
0
0
20.02.2014 20:48:35
0
0
0
S 
1
1
0
20.02.2014 20:48:35
0
0
0
0
0
2
0

29
syslnklgns
48
S 
4
0
0
0
0
0
20.02.2014 20:48:35
0
0
0
S 
1
1
0
20.02.2014 20:48:35
0
0
0
0
0
2
0

30
sysxprops
49
S 
4
0
0
0
0
0
13.04.2009 12:59:11
0
0
0
S 
1
1
0
13.04.2009 12:59:11
0
0
0
0
0
2
0

31
sysscalartypes
50
S 
4
0
0
0
0
0
13.04.2009 12:59:10
0
0
0
S 
1
1
0
13.04.2009 12:59:10
0
0
0
0
0
2
0

32
systypedsubobjs
51
S 
4
0
0
0
0
0
13.04.2009 12:59:11
0
0
0
S 
1
1
0
13.04.2009 12:59:11
0
0
0
0
0
2
0

33
sysidxstats
54
S 
4
0
0
0
0
0
13.04.2009 12:59:11
0
0
0
S 
1
1
0
13.04.2009 12:59:11
0
0
0
0
0
2
0

34
sysiscols
55
S 
4
0
0
0
0
0
13.04.2009 12:59:11
0
0
0
S 
1
1
0
13.04.2009 12:59:11
0
0
0
0
0
2
0

35
sysendpts
56
S 
4
0
0
0
0
0
20.02.2014 20:48:35
0
0
0
S 
1
1
0
20.02.2014 20:48:35
0
0
0
0
0
2
0

36
syswebmethods
57
S 
4
0
0
0
0
0
20.02.2014 20:48:35
0
0
0
S 
1
1
0
20.02.2014 20:48:35
0
0
0
0
0
2
0

37
sysbinobjs
58
S 
4
0
0
0
0
0
13.04.2009 12:59:12
0
0
0
S 
1
1
0
13.04.2009 12:59:12
0
0
0
0
0
2
0

38
sysaudacts
59
S 
4
0
0
0
0
0
20.02.2014 20:48:35
0
0
0
S 
1
1
0
20.02.2014 20:48:35
0
0
0
0
0
2
0

39
sysobjvalues
60
S 
4
0
0
0
0
0
13.04.2009 12:59:11
0
0
0
S 
1
1
0
13.04.2009 12:59:11
0
0
0
0
0
2
0

40
syscscolsegments
62
S 
4
0
0
0
0
0
20.02.2014 20:48:35
0
0
0
S 
1
1
0
20.02.2014 20:48:35
0
0
0
0
0
2
0

41
syscsdictionaries
63
S 
4
0
0
0
0
0
20.02.2014 20:48:35
0
0
0
S 
1
1
0
20.02.2014 20:48:35
0
0
0
0
0
2
0

42
sysclsobjs
64
S 
4
0
0
0
0
0
13.04.2009 12:59:11
0
0
0
S 
1
1
0
13.04.2009 12:59:11
0
0
0
0
0
2
0

43
sysrowsetrefs
65
S 
4
0
0
0
0
0
13.04.2009 12:59:11
0
0
0
S 
1
1
0
13.04.2009 12:59:11
0
0
0
0
0
2
0

44
sysremsvcbinds
67
S 
4
0
0
0
0
0
13.04.2009 12:59:12
0
0
0
S 
1
1
0
13.04.2009 12:59:12
0
0
0
0
0
2
0

45
sysxmitqueue
68
S 
4
0
0
0
0
0
13.04.2009 12:59:12
0
0
0
S 
1
1
0
13.04.2009 12:59:12
0
0
0
0
0
2
0

46
sysrts
69
S 
4
0
0
0
0
0
13.04.2009 12:59:12
0
0
0
S 
1
1
0
13.04.2009 12:59:12
0
0
0
0
0
2
0

47
sysconvgroup
71
S 
4
0
0
0
0
0
13.04.2009 12:59:12
0
0
0
S 
1
1
0
13.04.2009 12:59:12
0
0
0
0
0
2
0

48
sysdesend
72
S 
4
0
0
0
0
0
13.04.2009 12:59:12
0
0
0
S 
1
1
0
13.04.2009 12:59:12
0
0
0
0
0
2
0

49
sysdercv
73
S 
4
0
0
0
0
0
13.04.2009 12:59:13
0
0
0
S 
1
1
0
13.04.2009 12:59:13
0
0
0
0
0
2
0

50
syssingleobjrefs
74
S 
4
0
0
0
0
0
13.04.2009 12:59:10
0
0
0
S 
1
1
0
13.04.2009 12:59:10
0
0
0
0
0
2
0

51
sysmultiobjrefs
75
S 
4
0
0
0
0
0
13.04.2009 12:59:10
0
0
0
S 
1
1
0
13.04.2009 12:59:10
0
0
0
0
0
2
0

52
sysguidrefs
78
S 
4
0
0
0
0
0
13.04.2009 12:59:12
0
0
0
S 
1
1
0
13.04.2009 12:59:12
0
0
0
0
0
2
0

53
sysfoqueues
79
S 
4
0
0
0
0
0
20.02.2014 20:48:35
0
0
0
S 
1
1
0
20.02.2014 20:48:35
0
0
0
0
0
2
0

54
syschildinsts
80
S 
4
0
0
0
0
0
20.02.2014 20:48:35
0
0
0
S 
1
1
0
20.02.2014 20:48:35
0
0
0
0
0
2
0

55
syscompfragments
82
S 
4
0
0
0
0
0
20.02.2014 20:48:35
0
0
0
S 
1
1
0
20.02.2014 20:48:35
0
0
0
0
0
2
0

56
sysftsemanticsdb
84
S 
4
0
0
0
0
0
20.02.2014 20:48:35
0
0
0
S 
1
1
0
20.02.2014 20:48:35
0
0
0
0
0
2
0

57
sysftstops
85
S 
4
0
0
0
0
0
20.02.2014 20:48:35
0
0
0
S 
1
1
0
20.02.2014 20:48:35
0
0
0
0
0
2
0

58
sysftproperties
86
S 
4
0
0
0
0
0
20.02.2014 20:48:35
0
0
0
S 
1
1
0
20.02.2014 20:48:35
0
0
0
0
0
2
0

59
sysxmitbody
87
S 
4
0
0
0
0
0
20.02.2014 20:48:35
0
0
0
S 
1
1
0
20.02.2014 20:48:35
0
0
0
0
0
2
0

60
sysfos
89
S 
4
0
0
0
0
0
20.02.2014 20:48:35
0
0
0
S 
1
1
0
20.02.2014 20:48:35
0
0
0
0
0
2
0

61
sysqnames
90
S 
4
0
0
0
0
0
13.04.2009 12:59:12
0
0
0
S 
1
1
0
13.04.2009 12:59:12
0
0
0
0
0
2
0

62
sysxmlcomponent
91
S 
4
0
0
0
0
0
13.04.2009 12:59:12
0
0
0
S 
1
1
0
13.04.2009 12:59:12
0
0
0
0
0
2
0

63
sysxmlfacet
92
S 
4
0
0
0
0
0
13.04.2009 12:59:12
0
0
0
S 
1
1
0
13.04.2009 12:59:12
0
0
0
0
0
2
0

64
sysxmlplacement
93
S 
4
0
0
0
0
0
13.04.2009 12:59:12
0
0
0
S 
1
1
0
13.04.2009 12:59:12
0
0
0
0
0
2
0

65
sysobjkeycrypts
94
S 
4
0
0
0
0
0
13.04.2009 12:59:13
0
0
0
S 
1
1
0
13.04.2009 12:59:13
0
0
0
0
0
2
0

66
sysasymkeys
95
S 
4
0
0
0
0
0
13.04.2009 12:59:13
0
0
0
S 
1
1
0
13.04.2009 12:59:13
0
0
0
0
0
2
0

67
syssqlguides
96
S 
4
0
0
0
0
0
13.04.2009 12:59:13
0
0
0
S 
1
1
0
13.04.2009 12:59:13
0
0
0
0
0
2
0

68
sysbinsubobjs
97
S 
4
0
0
0
0
0
13.04.2009 12:59:12
0
0
0
S 
1
1
0
13.04.2009 12:59:12
0
0
0
0
0
2
0

69
syssoftobjrefs
98
S 
4
0
0
0
0
0
20.02.2014 20:48:35
0
0
0
S 
1
1
0
20.02.2014 20:48:35
0
0
0
0
0
2
0

70
sqlagent_jobs
101575400
IT
4
0
0
0
0
0
20.02.2014 20:48:35
0
0
0
IT
0
0
0
20.02.2014 20:48:35
0
0
0
0
0
2
0

71
sqlagent_jobsteps
117575457
IT
4
0
0
0
0
0
20.02.2014 20:48:35
0
0
0
IT
0
0
0
20.02.2014 20:48:35
0
0
0
0
0
2
0

72
sqlagent_job_history
133575514
IT
4
0
0
0
0
0
20.02.2014 20:48:35
0
0
0
IT
0
0
0
20.02.2014 20:48:35
0
0
0
0
0
2
0

73
sqlagent_jobsteps_logs
149575571
IT
4
0
0
0
0
0
20.02.2014 20:48:35
0
0
0
IT
0
0
0
20.02.2014 20:48:35
0
0
0
0
0
2
0

74
Pilots
245575913
U 
1
0
0
0
0
0
07.11.2015 13:52:38
0
0
0
U 
1
3
0
07.11.2015 13:52:38
0
0
0
0
0
0
0

75
PK_Pilots
261575970
PK
1
0
0
0
0
245575913
07.11.2015 13:52:38
0
0
0
K 
0
9
0
07.11.2015 13:52:38
0
0
0
0
0
0
0

76
FK_Pilots_Pilots
277576027
F 
1
0
0
0
0
245575913
07.11.2015 13:53:00
0
0
0
F 
0
11
0
07.11.2015 13:53:00
0
0
0
0
0
0
0

77
Planes
293576084
U 
1
0
0
0
0
0
07.11.2015 14:00:38
0
0
0
U 
1
3
0
07.11.2015 14:00:38
0
0
0
0
0
0
0

78
PK_Planes
309576141
PK
1
0
0
0
0
293576084
07.11.2015 14:00:38
0
0
0
K 
0
9
0
07.11.2015 14:00:38
0
0
0
0
0
0
0

79
Flights
325576198
U 
1
0
0
0
0
0
07.11.2015 14:08:28
0
0
0
U 
1
3
0
07.11.2015 14:08:28
0
0
0
0
0
0
0

80
PK_Flights
341576255
PK
1
0
0
0
0
325576198
07.11.2015 14:08:28
0
0
0
K 
0
9
0
07.11.2015 14:08:28
0
0
0
0
0
0
0

81
FK_Flights_Planes
357576312
F 
1
0
0
0
0
325576198
07.11.2015 14:09:16
0
0
0
F 
0
11
0
07.11.2015 14:09:16
0
0
0
0
0
0
0

82
Pilots_on_flights
373576369
U 
1
0
0
0
0
0
07.11.2015 14:12:18
0
0
0
U 
1
3
0
07.11.2015 14:12:18
0
0
0
0
0
0
0

83
PK_Pilots_on_flights
389576426
PK
1
0
0
0
0
373576369
07.11.2015 14:12:18
0
0
0
K 
0
9
0
07.11.2015 14:12:18
0
0
0
0
0
0
0

84
FK_Pilots_on_flights_Flights
405576483
F 
1
0
0
0
0
373576369
07.11.2015 14:13:40
0
0
0
F 
0
11
0
07.11.2015 14:13:40
0
0
0
0
0
0
0

85
FK_Pilots_on_flights_Pilots
421576540
F 
1
0
0
0
0
373576369
07.11.2015 14:13:40
0
0
0
F 
0
11
0
07.11.2015 14:13:40
0
0
0
0
0
0
0

86
alumnos
798882208
U 
1
0
0
0
0
0
30.09.2020 04:29:03
0
0
0
U 
1
3
0
30.09.2020 04:29:03
0
0
0
0
0
0
0

87
TT_StrList_71FCB56E
1912386926
TT
4
0
0
0
0
0
20.01.2020 06:47:45
0
0
0
TT
0
0
0
20.01.2020 06:47:45
0
0
0
0
0
2
0

88
GetAttr
1928386983
IF
1
0
0
0
0
0
20.01.2020 06:47:45
0
0
0
IF
0
0
0
20.01.2020 06:47:45
0
0
0
0
0
0
0

89
QueryNotificationErrorsQueue
1977058079
SQ
1
0
0
0
0
0
13.04.2009 12:59:13
0
0
0
SQ
0
0
0
13.04.2009 12:59:13
0
0
0
0
0
2
0

90
queue_messages_1977058079
1993058136
IT
4
0
0
0
0
1977058079
13.04.2009 12:59:13
0
0
0
IT
0
0
0
13.04.2009 12:59:13
0
0
0
0
0
2
0

91
EventNotificationErrorsQueue
2009058193
SQ
1
0
0
0
0
0
13.04.2009 12:59:13
0
0
0
SQ
0
0
0
13.04.2009 12:59:13
0
0
0
0
0
2
0

92
queue_messages_2009058193
2025058250
IT
4
0
0
0
0
2009058193
13.04.2009 12:59:13
0
0
0
IT
0
0
0
13.04.2009 12:59:13
0
0
0
0
0
2
0

93
ServiceBrokerQueue
2041058307
SQ
1
0
0
0
0
0
13.04.2009 12:59:13
0
0
0
SQ
0
0
0
13.04.2009 12:59:13
0
0
0
0
0
2
0

94
queue_messages_2041058307
2057058364
IT
4
0
0
0
0
2041058307
13.04.2009 12:59:13
0
0
0
IT
0
0
0
13.04.2009 12:59:13
0
0
0
0
0
2
0

95
filestream_tombstone_2073058421
2073058421
IT
4
0
0
0
0
0
20.02.2014 20:48:35
0
0
0
IT
0
0
0
20.02.2014 20:48:35
0
0
0
0
0
2
0

96
t
2086107843
U 
1
0
0
0
0
0
01.10.2019 10:16:54
0
0
0
U 
1
3
0
01.10.2019 10:16:54
0
0
0
0
0
0
0

97
syscommittab
2089058478
IT
4
0
0
0
0
0
20.02.2014 20:48:35
0
0
0
IT
0
0
0
20.02.2014 20:48:35
0
0
0
0
0
2
0

98
filetable_updates_2105058535
2105058535
IT
4
0
0
0
0
0
20.02.2014 20:48:35
0
0
0
IT
0
0
0
20.02.2014 20:48:35
0
0
0
0
0
2
0


  
name
id
xtype
uid
info
status
base_schema_ver
replinfo
parent_obj
crdate
ftcatid
schema_ver
stats_schema_ver
type
userstat
sysstat
indexdel
refdate
version
deltrig
instrig
updtrig
seltrig
category
cache

1
alumnos
798882208
U 
1
0
0
0
0
0
30.09.2020 04:29:03
0
0
0
U 
1
3
0
30.09.2020 04:29:03
0
0
0
0
0
0
0


  
TABLE_CATALOG
TABLE_SCHEMA
TABLE_NAME
TABLE_TYPE

1
rextester
dbo
Pilots
BASE TABLE

2
rextester
dbo
Planes
BASE TABLE

3
rextester
dbo
Flights
BASE TABLE

4
rextester
dbo
Pilots_on_flights
BASE TABLE

5
rextester
dbo
alumnos
BASE TABLE

6
rextester
dbo
t
BASE TABLE