Bhutan ICT
E-Learning, Web Design, Linux, PHP, Wordpress, Visual Studio .NET, Windows, SQL Server, ASP.NET, C#
Pages
Home
About
Privacy Policy
Oct 13, 2017
Get MySQL Database columns and datatypes
To get database details for specific database under MySQL use the following script. Execute the script in any DB tools like DBeaver etc.
select * from information_schema.columns
where table_schema = 'your_database_name'
No comments:
Post a Comment
Newer Post
Older Post
Home
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment