TECHNOLOGIES
FORUMS
JOBS
BOOKS
EVENTS
INTERVIEWS
Live
MORE
LEARN
Training
CAREER
MEMBERS
VIDEOS
NEWS
BLOGS
Sign Up
Login
No unread comment.
View All Comments
No unread message.
View All Messages
No unread notification.
View All Notifications
Answers
Post
An Article
A Blog
A News
A Video
An EBook
An Interview Question
Ask Question
Forums
Monthly Leaders
Forum guidelines
Jitendra Kumar
484
2.9k
842.8k
Query that returns all tables order by Primary foreign const
Apr 21 2016 3:23 AM
Here is the simple SQL query that will return all tables from the database order by primary foreign constraints.
SELECT t.TABLE_NAME FROM INFORMATION_SCHEMA.TABLES t
Left Join INFORMATION_SCHEMA.CONSTRAINT_TABLE_USAGE cu on t.TABLE_NAME=cu.TABLE_NAME WHERE t.TABLE_TYPE = 'BASE TABLE'
Order by cu.CONSTRAINT_NAME desc
or
Select * from sys.tables t
Inner join sys.objects o on o.object_id=t.object_id
I perform insert statement these so that I want tables in primary foreign order.
otherwise, I get the error like this
The INSERT statement conflicted with the FOREIGN KEY constraint "FK_emp1". The conflict occurred in database "
testdata
", table "
dbo
.Emp".
However, what I would like to do here is to get all the tables order by primary foreign constraints. How should I query this?
Thank you very much.
Reply
Answers (
1
)
Image convert into bytes and save in sql
Employee leave day