Cursusomgeving Data-Docent
Home
Effectieve Business Intelligence
Data Gedreven Werken
Databases
SQL
Tabel en kolom selectie
Schema en tabelnaam
[54707_SA].[Assignment]
[54707_SA].[Codelist]
[54707_SA].[ImportBRT2020]
[54707_SA].[ImportGEM2020]
[54707_SA].[ImportKNMI2022]
[54707_SA].[ImportPC6GWB2020]
[54707_SA].[Statement]
[ALBERTO].[Bestelling]
[ALBERTO].[Bezorger]
[ALBERTO].[Bezorging]
[ALBERTO].[BezorgingEvaluatie]
[ALBERTO].[DataMart_Bestelling]
[ALBERTO].[Datamart_Bezorging]
[ALBERTO].[DimDatum]
[ALBERTO].[DimGeografie]
[ALBERTO].[DimKlimaat]
[ALBERTO].[DimProductCategorie]
[ALBERTO].[DimVestiging]
[ALBERTO].[EBIStatement]
[ALBERTO].[FactBestelling]
[ALBERTO].[Felicitatie]
[ALBERTO].[Felicitaties]
[ALBERTO].[person]
[ALBERTO].[person_type]
[ALBERTO].[Personen]
[ALBERTO].[Persoon]
[ALBERTO].[ProductVerkoop]
[ALBERTO].[Relatietypes]
[ALBERTO].[VerkoopDashboard]
[ALBERTO].[VerkoopPivot]
[ALBERTO].[Vestiging]
[ALBERTO].[Vestiging_Bezorger]
[C_BERT].[Evaluation]
[C_BERT].[ExtraEvaluation]
[C_JANOTTO].[Felicitatie]
[C_JEAN].[DEMO]
[C_JELLE].[Felicitatie]
[C_JOSHUA].[VERJAARDAGEN]
[C_MARGOTWR].[Felicitatie]
[C_MARGOTWR].[Personeel]
[C_MARGOTWR].[Persoon]
[C_MARGOTWR].[Test]
[C_MENNA].[Opdracht]
[C_MISCHA].[Opdracht]
[DATAFUEL].[AuTotaal]
[DATAFUEL].[Autoverbruik]
[DBO].[sysdiagrams]
[FELICITATIE].[Contactpersoon]
[FELICITATIE].[Contactpersoon_Gebeurtenis]
[FELICITATIE].[FelicitatieLijst]
[FELICITATIE].[Gebeurtenis]
[NORTHWIND].[Alphabetical list of products]
[NORTHWIND].[Categories]
[NORTHWIND].[Category Sales for 1997]
[NORTHWIND].[Current Product List]
[NORTHWIND].[Customer and Suppliers by City]
[NORTHWIND].[CustomerCustomerDemo]
[NORTHWIND].[CustomerDemographics]
[NORTHWIND].[Customers]
[NORTHWIND].[Employees]
[NORTHWIND].[EmployeeTerritories]
[NORTHWIND].[Invoices]
[NORTHWIND].[Order Details Extended]
[NORTHWIND].[Order Details]
[NORTHWIND].[Order Subtotals]
[NORTHWIND].[Orders Qry]
[NORTHWIND].[Orders]
[NORTHWIND].[Product Sales for 1997]
[NORTHWIND].[Products Above Average Price]
[NORTHWIND].[Products by Category]
[NORTHWIND].[Products]
[NORTHWIND].[Quarterly Orders]
[NORTHWIND].[Region]
[NORTHWIND].[Sales by Category]
[NORTHWIND].[Sales Totals by Amount]
[NORTHWIND].[Shippers]
[NORTHWIND].[Summary of Sales by Quarter]
[NORTHWIND].[Summary of Sales by Year]
[NORTHWIND].[Suppliers]
[NORTHWIND].[Territories]
[RESTAURANTDEMO].[City]
[RESTAURANTDEMO].[friendOf]
[RESTAURANTDEMO].[likes]
[RESTAURANTDEMO].[livesIn]
[RESTAURANTDEMO].[locatedIn]
[RESTAURANTDEMO].[Person]
[RESTAURANTDEMO].[Restaurant]
[RESTAURANTDEMO].[Restaurantdocument]
Schema en tabel combinatie is verplicht
Constraint type
Primaire sleutel
Verwijzende sleutel
Check constraint
Kolomnaam
Verwijzing naar tabel
[54707_SA].[Assignment]
[54707_SA].[Codelist]
[54707_SA].[ImportBRT2020]
[54707_SA].[ImportGEM2020]
[54707_SA].[ImportKNMI2022]
[54707_SA].[ImportPC6GWB2020]
[54707_SA].[Statement]
[ALBERTO].[Bestelling]
[ALBERTO].[Bezorger]
[ALBERTO].[Bezorging]
[ALBERTO].[BezorgingEvaluatie]
[ALBERTO].[DataMart_Bestelling]
[ALBERTO].[Datamart_Bezorging]
[ALBERTO].[DimDatum]
[ALBERTO].[DimGeografie]
[ALBERTO].[DimKlimaat]
[ALBERTO].[DimProductCategorie]
[ALBERTO].[DimVestiging]
[ALBERTO].[EBIStatement]
[ALBERTO].[FactBestelling]
[ALBERTO].[Felicitatie]
[ALBERTO].[Felicitaties]
[ALBERTO].[person]
[ALBERTO].[person_type]
[ALBERTO].[Personen]
[ALBERTO].[Persoon]
[ALBERTO].[ProductVerkoop]
[ALBERTO].[Relatietypes]
[ALBERTO].[VerkoopDashboard]
[ALBERTO].[VerkoopPivot]
[ALBERTO].[Vestiging]
[ALBERTO].[Vestiging_Bezorger]
[C_BERT].[Evaluation]
[C_BERT].[ExtraEvaluation]
[C_JANOTTO].[Felicitatie]
[C_JEAN].[DEMO]
[C_JELLE].[Felicitatie]
[C_JOSHUA].[VERJAARDAGEN]
[C_MARGOTWR].[Felicitatie]
[C_MARGOTWR].[Personeel]
[C_MARGOTWR].[Persoon]
[C_MARGOTWR].[Test]
[C_MENNA].[Opdracht]
[C_MISCHA].[Opdracht]
[DATAFUEL].[AuTotaal]
[DATAFUEL].[Autoverbruik]
[DBO].[sysdiagrams]
[FELICITATIE].[Contactpersoon]
[FELICITATIE].[Contactpersoon_Gebeurtenis]
[FELICITATIE].[FelicitatieLijst]
[FELICITATIE].[Gebeurtenis]
[NORTHWIND].[Alphabetical list of products]
[NORTHWIND].[Categories]
[NORTHWIND].[Category Sales for 1997]
[NORTHWIND].[Current Product List]
[NORTHWIND].[Customer and Suppliers by City]
[NORTHWIND].[CustomerCustomerDemo]
[NORTHWIND].[CustomerDemographics]
[NORTHWIND].[Customers]
[NORTHWIND].[Employees]
[NORTHWIND].[EmployeeTerritories]
[NORTHWIND].[Invoices]
[NORTHWIND].[Order Details Extended]
[NORTHWIND].[Order Details]
[NORTHWIND].[Order Subtotals]
[NORTHWIND].[Orders Qry]
[NORTHWIND].[Orders]
[NORTHWIND].[Product Sales for 1997]
[NORTHWIND].[Products Above Average Price]
[NORTHWIND].[Products by Category]
[NORTHWIND].[Products]
[NORTHWIND].[Quarterly Orders]
[NORTHWIND].[Region]
[NORTHWIND].[Sales by Category]
[NORTHWIND].[Sales Totals by Amount]
[NORTHWIND].[Shippers]
[NORTHWIND].[Summary of Sales by Quarter]
[NORTHWIND].[Summary of Sales by Year]
[NORTHWIND].[Suppliers]
[NORTHWIND].[Territories]
[RESTAURANTDEMO].[City]
[RESTAURANTDEMO].[friendOf]
[RESTAURANTDEMO].[likes]
[RESTAURANTDEMO].[livesIn]
[RESTAURANTDEMO].[locatedIn]
[RESTAURANTDEMO].[Person]
[RESTAURANTDEMO].[Restaurant]
[RESTAURANTDEMO].[Restaurantdocument]
Check constraint
SQL Query
Log
Log
Resultatenlog