Manipulating the db with SQL Server 2005 - Django

Question

I'm trying to accomplish the following:

Grab the db schema
Grab any constraints*
Alter tables
Add/Drop tables

I'm currently using pyodbc backend for Django.

I would like to perform all these tasks within a view file.

I'm using the following in order to grab fields of tables starting with 'core_':

SELECT  table_name,ordinal_position,column_name,data_type,
is_nullable,character_maximum_length FROM
information_schema.COLUMNS WHERE table_name LIKE 'core_%'
ORDER BY ordinal_position

*Fixed thanks to Madhivanan Link

Any ideas to get started?

Madhivanan · Accepted Answer · 2010-06-30 12:56:41Z

3

Try this by using a wildcard %

SELECT  table_name,ordinal_position,column_name,data_type, 
is_nullable,character_maximum_length FROM 
information_schema.COLUMNS WHERE table_name LIKE 'core_%' 
ORDER BY ordinal_position

answered Jun 30, 2010 at 12:56

Madhivanan

13.7k1 gold badge28 silver badges30 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Manipulating the db with SQL Server 2005 - Django

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related