information-schema – CodeRavo

Retrieving Table Metadata in SQL Server

When working with databases, it’s often necessary to retrieve metadata about the tables, such as column … Retrieving Table Metadata in SQL ServerRead more

column names, data types, information-schema, nullability, primary-key-constraints, SQL Server, system views, table-metadata

Retrieving Stored Procedure Names in SQL Server

In SQL Server, stored procedures are reusable blocks of code that perform a specific task. They … Retrieving Stored Procedure Names in SQL ServerRead more

database administration, information-schema, SQL Server, stored procedures, sys-procedures, sysobjects

Understanding MySQL Character Sets for Databases, Tables, and Columns

Introduction In a relational database management system (RDBMS) like MySQL, understanding character sets is crucial for … Understanding MySQL Character Sets for Databases, Tables, and ColumnsRead more

character-set, column-encoding, database schema, information-schema, latin1, MySQL, table-metadata, utf8

Calculating MySQL Database Size

Calculating the size of a MySQL database is an essential task for database administrators and developers. … Calculating MySQL Database SizeRead more

database-size, information-schema, InnoDB, myisam, MySQL, phpmyadmin

Retrieving Table Metadata in SQL Server

In SQL Server, understanding the structure of a table is crucial for effective database management and … Retrieving Table Metadata in SQL ServerRead more

Database Management, information-schema, sp-columns, sp-help, SQL Server, table-metadata

Searching for Text Within SQL Server Stored Procedures

Finding Text Within SQL Server Stored Procedures Often, when maintaining or debugging a SQL Server database, … Searching for Text Within SQL Server Stored ProceduresRead more

database-maintenance, debugging, information-schema, search, SQL Queries, SQL Server, stored procedures, sys-sql-modules, syscomments, text-search

Understanding and Querying MySQL Table Sizes

Welcome to this tutorial where we will explore how to determine the size of tables within … Understanding and Querying MySQL Table SizesRead more

data-length, database-optimization, index-length, information-schema, MySQL, table-size

Retrieving Table Schemas: Listing Database Columns

Understanding Database Schemas Databases organize data into tables, and each table is defined by a schema. … Retrieving Table Schemas: Listing Database ColumnsRead more

column-list, database, information-schema, metadata, MySQL, oracle, PostgreSQL, SQL, SQL Server, table-schema

Exploring PostgreSQL Table Structures: Techniques for Describing Tables

Introduction In database management, understanding a table’s structure is crucial. While Oracle uses DESCRIBE TABLE to … Exploring PostgreSQL Table Structures: Techniques for Describing TablesRead more

describe-table, information-schema, metadata, PostgreSQL, psql, system-catalog, table-structure

Checking and Adding Columns in SQL Server Tables

Introduction In database management, it’s common to encounter scenarios where you need to modify a table’s … Checking and Adding Columns in SQL Server TablesRead more

alter table, col-length, columns-existence-check, Database Management, information-schema, SQL Server, sys-columns