Results 1 to 1 of 1
Apr 4, 2014, 12:00 #1
- Join Date
- Jun 2008
- Madison, WI
- 34 Post(s)
- 2 Thread(s)
Get primary keys for ALL tables in a given DB?
I am using the following bit of SQL to get a list of the primary keys in my DB , named 'RMCMS':
SELECT `COLUMN_NAME` , `TABLE_NAME` FROM `statistics` WHERE `INDEX_SCHEMA` = 'RMCMS' AND `INDEX_NAME` = 'PRIMARY' LIMIT 0 , 30
Thanks in advanceTips for better/ faster SitePoint forum answers
Brilliant ideas, elegant execution.
Graphic Design, Art Direction, Copywriting and Web Design.