Retrieving a list of SQL Server objects (constraints, tables, views, functions) using sys.objects

preview_player
Показать описание
How can you retrieve a list of all of your constraints, functions, tables, procedures and views? It's very easy.
My SQL Server Udemy courses are:
----
However, you can develop it very easily, by getting the Schema Name and the Parent Object Name - for example, what table a constraint is in? The code I develop in this video is:
SELECT Schema_NAME(O.schema_id) as SchemaName, object_name(O.parent_object_id) as ParentObjectName, O.*
  1. SQL Server 101
  2. sql server
  3. sql
  4. microsoft sql server
  5. sql server learn
  6. sql server videos
Рекомендации по теме
SQL Tutorial for 0:07:15

SQL Tutorial for Beginners 4: SELECT - Retrieving Records from Your Database

SQL Tips | 0:00:23

SQL Tips | How to Find All Tables containing a Column? #sqltips

SELECT query in 0:07:21

SELECT query in SQL - Retrieval of records from a table

#SQL Query to 0:00:56

#SQL Query to see all tables in a database?? #datascience #mssql #coding

#SQL How to 0:00:33

#SQL How to See All Columns in a Table? #datascience #coding #programming #mssql #databasemanagement

How to find 0:00:58

How to find all the database tables having column name EmployeeId #shorts #coding #sql #sqlqueries

Practice Complex SQL 0:25:33

Practice Complex SQL Queries | SQL Query to fetch N consecutive records

#SQL How to 0:00:54

#SQL How to Find Duplicates in a Table? #datascience #programming #coding #sqltutorial

MCQs | SUBQUERIES 0:56:16

MCQs | SUBQUERIES AND COMPLEX QUERIES | DBMS | RPSC ACP EXAM 2024 | SURESH SONI | PART 2

how to get 0:00:58

how to get list of all tables from Oracle database

SQL indexing best 0:04:08

SQL indexing best practices | How to make your database FASTER!

How do you 0:00:22

How do you scrape data 100X faster? Bet you didn’t know this Google Sheets formula!

Insert a List 0:00:54

Insert a List of Dictionaries into a SQL database #python #shorts

fetch first and 0:00:13

fetch first and last record from table using sql

How to get 0:00:38

How to get COLUMN NAMES in SQL

Basic SQL Commands 0:00:06

Basic SQL Commands #sql #sqlserver #basic #sqlbasics

SQL Query To 0:00:20

SQL Query To Print the Details of Employees Whose first_name ends with 't' | #SQL #intervi...

SQL Query | 0:06:23

SQL Query | How to find employees hired in last n months | Datediff

Practice Writing SQL 0:54:41

Practice Writing SQL Queries using Real Dataset(Practice Complex SQL Queries)

Power Automate 101 0:06:11

Power Automate 101 | SQL Server Actions

How to Find 0:00:28

How to Find Companies ACTUALLY Hiring

SQL SERVER: OFFSET 0:00:21

SQL SERVER: OFFSET and FETCH Clause (Retrieve a Range of Records)

How to SHOW 0:00:56

How to SHOW ALL TABLES In Oracle and SQL Server #learnsql

SQL Injection 101: 0:00:33

SQL Injection 101: Exploiting Vulnerabilities

Комментарии
Автор

Hey there, glad to meet you again
As a new newbie, i learned that views are specialized ways of looking at the actual data.
How actually views are displayed in sql? Do they actually alter the physical data?
Are they stored in temporary tables?
Thanks for taking care of my enquiries.

hasanmougharbel
join shbcf.ru