The information schema is a set of views providing metadata for objects in relational databases: tables, views, columns, stored procedures, accounts etc.
What is the recommended way to figure out if a user got a certain right (e.g. select or execute) …
postgresql metadata privileges information-schemaI want to check if innodb_file_per_table is set (i.e .ibd is created) for each database tables …
mysql innodb information-schema mysql-5.5When i'm create new user or grant privileges to existing, i got this error: ERROR 1045 (28000): Access denied for user 'root'@…
mysql information-schemaI have the following query: SHOW TABLES LIKE '$prefix%' It works exactly how I want it to, though …
php mysql pagination information-schemaThe following query used to work: select * from information_schema.columns where column_name like ... But now it's throwing an …
sql-server information-schemaInitially I would like to ask you to forget about hashing passwords or w/e related to passwords, this question …
database performance database-design information-schemaHow do I just print out a 'primary key' for the column with the primary key? I get 'primary key' …
sql-server sql-server-2005 primary-key constraints information-schemaI know that so far (until MSSQL 2005 at least), system databases are master, model, msdb and tempdb. Thing is, as …
sql-server-2005 information-schemaI have this query that finds all tables and views that matches my column name of a certain database. I …
sql-server-2008 information-schemaMy database is getting old, and one of my biggest INT IDENTITY columns has a value around 1.3 billion. This will …
sql-server overflow maintenance identity-column information-schema