SCHEMA() - Synonym for DATABASE()

SCHEMA() - Synonym for DATABASE()

Q

What's the difference between SCHEMA() and DATABASE() functions?

✍: FYIcenter.com

A

SCHEMA() is a synonym for the DATABASE() function.

Related MySQL functions:

⇒ SESSION_USER() - Synonym for USER()

⇐ ROW_COUNT() - Affected Rows from Last DML Statement

⇑ MySQL Functions on System Information

⇑⇑ MySQL Function References

2025-02-16, 3514🔥, 0💬

Popular Posts:

COERCIBILITY() - Cha...

How to detect the collation coercibility associated to a given character string using the COERCIBILI...

WHILE ... Loops in S...

How to execute statements in loops in SQL Server Transact-SQL? How to use WHILE ... loops? You can u...

DATEADD() Function U...

How To Use DATEADD() Function in SQL Server Transact-SQL? DATEADD() is a very useful function for ma...

Counting Rows with t...

How To Count Rows with the COUNT(*) Function in SQL Server? If you want to count the number of rows,...

Arithmetic Operation...

What Happens to an Arithmetic Operation with Two Different Data Types in SQL Server Transact-SQL? Wh...